Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I'm trying to generate an API query which takes multiple webids as input from table values.
If I directly type the query as below I get the response:
The Query works as below, passing each webid seperately.
However, If I pass the webids from a table value (Custom Invoke using Json.Document(Web.Content("https:/apiserver.com/piwebapi/streamsets/value",[Query=[webid={ Column1}]])), the URL is getting passed with only webid as whole
How to make this work so that all the value from the Coloumn can be passed in the query and it considers as seperate WebIds.
Solved! Go to Solution.
Hi @prabhat_m ,
Please update the code as below and check if it can work or not...
Json.Document(
Web.Content(
"https:/apiserver.com/piwebapi/streamsets/value",
[Query = [webid = Text.Split([Column1], ",")]]
)
)
Any comment or problem, please feel free to let me know.
Best Regards
@prabhat_m , Please check if this can help you
Thank Amit.
I'm using the same to form tables where cow from the example is webid.
I am trying to pass multiple query parameter for ex: Query=[q="cow","goat","dog"] which workis in the API that I'm using if I harcode it. It makes propoer query as api?q=cow&q=goat&q=dog and goes through.
However if I pass "Cow","goat","dog" from a coloum in a table, it is not working and the query becomes api?q="cow","goat","dog" which is incorrect format
Hi @prabhat_m ,
Please update the code as below and check if it can work or not...
Json.Document(
Web.Content(
"https:/apiserver.com/piwebapi/streamsets/value",
[Query = [webid = Text.Split([Column1], ",")]]
)
)
Any comment or problem, please feel free to let me know.
Best Regards
Worked like a charm!!
Thank you!
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |