Skip to main content
Solved

Rest data source - Json-stat format

  • February 11, 2025
  • 1 reply
  • 34 views

Hi 

 

Does the rest data source support json-stat format? Is it able to interpret it and transform it into a structured table? I tried using the JSON data format, but I received an XML file that the ODX could not extract any columns from.

 

Best answer by Thomas Lind

Hi ​@annfoss 

For now the data format is more about forcing the setup to read it as either JSON, XML or CSV.

The text option is explained here https://support.timextender.com/data-sources-112/timextender-rest-data-source-1660?tid=1660&fid=112#Data+Format.

It is not about how the JSON is structured it is about what type the source returns.

In our old CData guide for JSON we have some options for the format, what option would fit the setup you get from this source?

https://support.timextender.com/data-sources-112/connect-to-json-785?tid=785&fid=112#Using+the+JSON+Format+field

View original
Did this topic help you find an answer to your question?

1 reply

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1017 replies
  • Answer
  • February 12, 2025

Hi ​@annfoss 

For now the data format is more about forcing the setup to read it as either JSON, XML or CSV.

The text option is explained here https://support.timextender.com/data-sources-112/timextender-rest-data-source-1660?tid=1660&fid=112#Data+Format.

It is not about how the JSON is structured it is about what type the source returns.

In our old CData guide for JSON we have some options for the format, what option would fit the setup you get from this source?

https://support.timextender.com/data-sources-112/connect-to-json-785?tid=785&fid=112#Using+the+JSON+Format+field


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings