Forum Discussion

Wikus

New Contributor III

3 years ago

Solved

Json data

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

Data Integration

JackLacava
3 years ago
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

JackLacava

Honored Contributor

3 years ago

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

New Contributor II

12 months ago

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.

Forum Discussion

Json data

Related Content

Log anything with JSON

GetDataBufferDataCells with no data

Data Integration

Copy Data Data Management Step and Derived Real Data

Data management Sequence