Skip to main content
Solved

Rest data source - Json-stat format

  • February 11, 2025
  • 1 reply
  • 42 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

1 reply

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1161 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