Json data

[Wikus]

Hi,

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

Thanks

[JackLacava · Accepted solution]

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]

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.

[Wikus]

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