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!