Skip to main content
W
Wikus
November 24, 2022
Solved

Json data

  • November 24, 2022
  • 2 replies
  • 0 views

Hi,

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

Thanks

Best answer by JackLacava

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

2 replies

J
JackLacavaAnswer
November 24, 2022

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

B
Brooks
February 15, 2024

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.

W
WikusAuthor
November 25, 2022

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

Terms & ConditionsAccessibility statement