Forum Discussion
Desktop - Get Data from multiple JSON sources
Hi Steve0212,
According to your description above, using Query Parameters should be an option here in your scenario. You can create different Parameters for your servers and operations, then referencing these parameters on each input field on the Data Source dialog like below.
Within the Report view, users can edit parameter values by using the “Edit Parameters” button in the Home ribbon tab (under “Edit Queries”). This will bring up a dialog to allow users to reconfigure parameter values and will refresh the data and report visuals based on the new parameter values.
For more details about Query Parameters, you can refer to this article. :smileyhappy:
Regards
Thank you for the reply. So, using that, could I create one dataset of web (for one of the REST calls), using advanced and parameters and then put it on the report multiple times with different parameters?
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