JSON call to fill data in a column

Hello,


I was wondering if there's a way to fill a column of data from a JSON web service call?


Here's the example to work with


Column 1 Column 2 Column 3 Column 4 Column 5
Name 1 Param1 for 1 Param2 for 1 Value 1 JSON call value
Name 2 Param1 for 2 Param2 for 2 Value 2 JSON call value
Name 3 Param1 for 3 Param2 for 3 Value 3 JSON call value
Name 4 Param1 for 4 Param2 for 4 Value 4 JSON call value
Name 5 Param1 for 5 Param2 for 5 Value 5 JSON call value

Column 2 and Column 3 are parameters for the web service call and I want to fill column 5 with a specific column from the JSON return. Is there any way to do this?

If it isn't possible, my alternative is to ask you guys if it's possible to return a specific value from a data set (it could be from another DBI cube or a SQL database lookup) from the same criteria above. Column 2 and 3 as parameters and it'll return a specific value from the data set.

Thanks in advance!

This is probaly not the write answer but more of a suggestion/Question to Dundas based off your need.

Can you use this https://www.dundas.com/Support/blog/connecting-to-json-data-in-dundas-bi#Connecting and this https://www.dundas.com/Support/support-center/support-articles/parameters-filters/using-a-bridge-parameter?v=4.0 together to achive his results?


I am not sure if the first link is able to just make a regular JSON WEB call or it only connects to a database with JSON connector?


Maybe this https://www.dundas.com/support/support-center/support-articles/data-connectors/connecting-to-jdbc


Or is it going to be a JavaScript call?


I think I woudl just put ina request to support if I had to do this, I do not have a JSON end point to play with.


This is possible using the Python analysis transform within the data cube. You can look at the following article that describes how you can extract JSON data via Python. It will then be a question of passing your parameters to the Python analysis transform script using placeholders in order to construct the JSON call and get the value back.

Thanks for this Ariel.


To use parameters in the web service call (URL) would I just have to define placeholders or parameters in the Python Data Generation setup?

It depends on where you want to make the web service call. If you already have the parameters values coming from another data source and just want to use those to construct the web service call then I would do so in the Python analysis transform. If all of the data you need to construct the web service call isn't available from an existing data connector than I would do it all Python data generator. Both transforms are very similar, the only difference is that one is initiating your data flow and the other is in middle so it can leverage other data transformation on route before being executed.