Parameterize Parameter in API Body in dataflow

Question

below is the image of the dynamic body in Web activity wherein I am leveraging a pipeline parameter

With the above set of configuration and values, the web activity is successfully getting executed.

Now for the same REST API, I am trying to use it as source in dataflow :

with the same aspect of configuration and it is failing with below error :

Dataflow param:

Error: ailure to read most recent page request: DF-REST_001 - Error response from server: Some({"error":{"code":"DatasetExecuteQueriesError","pbi.error":{"code":"DatasetExecuteQueriesError","parameters":{},"details":[{"code":"DetailsMessage","detail":{"type":1,"value":"The JSON DDL request failed with the following error: Invalid JavaScript property identifier character: }. Path '', line 1, position 7.."}},{"code":"AnalysisServicesErrorCode","detail":{"type":1,"value":"3239182519"}}]}}}), Status code: 400. Please check your request url and body.

Can someone please help what I am doing Wrong?

Why do you need {} around $Query? Is it not passing those to your API? — Jason Welch
– Jason Welch, Commented Oct 23, 2022 at 17:04
Are you able to successfully pass the body without any parameters? i.e., give body as {"queries":[{"query":"EVALUATE VALUES(Date)"}],"serializerSettings":{"includeNulls":true}}? — Saideep Arikontham
– Saideep Arikontham, Commented Oct 28, 2022 at 9:46
@SaideepArikontham, yes it is working without parameterizing. — Nandan
– Nandan, Commented Oct 28, 2022 at 10:10
Can you try to concat instead? like '{"queries":[{"query":"'+$query+'"}],"serializerSettings":{"includeNulls":true}} in the dataflow expression builder? — Saideep Arikontham
– Saideep Arikontham, Commented Oct 28, 2022 at 10:18
Hey @SaideepArikontham, I tried using concat and it worked. It means that string interpolation doesnt work in dataflows. but now there is another issue : learn.microsoft.com/en-us/answers/questions/1068265/… — Nandan
– Nandan, Commented Oct 30, 2022 at 15:37

Saideep Arikontham · Accepted Answer · 2022-11-01 06:19:04Z

1

To use dataflow parameter within the expression builder, we have to concatenate the parameter with our data. Look at the following demonstration.

I am using derived column to show how to use parameters within expression builder. Using the dynamic content same as yours, I get the following output:

'{"queries":[{"query":"{$query}"}],"serializerSettings":{"includeNulls":true}}'

enter image description here

String interpolation does not work in the dataflow expression builder. To get it correctly, you can concatenate the parameter using + to get desired result.

'{"queries":[{"query":"'+$query+'"}],"serializerSettings":{"includeNulls":true}}'

enter image description here

Using the following content in expression builder also works (using concat() function).

concat('{"queries":[{"query":"',$query,'"}],"serializerSettings":{"includeNulls":true}}')

answered Nov 1, 2022 at 6:19

Saideep Arikontham

6,1922 gold badges6 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Parameterize Parameter in API Body in dataflow

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related