Forum Discussion
Desktop - Get Data from multiple JSON sources
Hi Steve0212,
Based on my understanding, you may need to use the Web connector with advanced and parameters multiple times(maybe 5 of 20 or more in your scenario) to import your data into different queries(tables) in one dataset. Then you can edit the parameters to change and refresh the data tables among all the 20 based on the new parameter values.
I know it's not a perfect solution here, but it should somehow help in your scenario. :smileyhappy:
Regards
Using both of your suggestions, I can create a query with parameters and use the advanced setting to then use them in the URL. However, it appears to me that I can only set the parameter once per report. That will not work. I want a report that accesses all of the sources and puts the data together. This does not appear to be possible unless I create one dataset per JSON query which is what I am trying to avoid.
Am I missing something?
Hi Steve0212,
As I have mentioned above, it won't help much if you want to get all of the sources and put the data together at one time. But you can get parts of sources(let's say 5 of 20) each time, then change the parameters to get other parts of sources within a single dataset. :smileyhappy:
Regards