Skip to main content
Wikus
Member
Nov 24, 2022 5:33 AM UTC
Solved

Json data

Hi,

Can OneStream consume Json data (retrieved with a API from 3rd party system) or must it be converted?

Thanks

JackLacavaAnswer
Employee - Sage
Nov 24, 2022 12:40 PM UTC

OneStream includes the Newtonsoft.Json library, so yeah. Just make sure your Imports section (at the top of the Business Rule) contains a line "Imports Newtonsoft.Json". See this StackOverflow answer for a quickstart, there is more documentation if you google for it: https://stackoverflow.com/questions/48367318/parse-json-in-vb-net-with-newtonsoft-json-net

View in thread

3 replies

Employee - Sage
JackLacavaEmployee - SageAnswer
Employee - Sage
Nov 24, 2022 12:40 PM UTC

OneStream includes the Newtonsoft.Json library, so yeah. Just make sure your Imports section (at the top of the Business Rule) contains a line "Imports Newtonsoft.Json". See this StackOverflow answer for a quickstart, there is more documentation if you google for it: https://stackoverflow.com/questions/48367318/parse-json-in-vb-net-with-newtonsoft-json-net

    Brooks
    Contributor
    Feb 15, 2024 2:51 PM UTC

    This is really great.  How would I setup a SIC Direct Connect to pull this in?  It is very difficult to find detailed information on direct connections with SIC.

    Brooks
    WikusAuthor
    Member
    Nov 25, 2022 4:09 AM UTC

    Thank you, Jack. This is exactly what I was looking for.

      Terms & ConditionsAccessibility statement