ADF Dataflow error Parameter stream has parsing errors Parameter(s) with errors: testParam. Not honoring the datatype of parameter(s) could be one of the causes.

Question

Hi,

I am passing API response to a dataflow to write to a log file.

My api response is

"'<?xml version="1.0" encoding="UTF-8"?>\n<response success="true">\n <messages>\n <message key="warning-unmapped-level">Warning: No data was imported for rows : xyz,abc,def</message>\n </messages>\n</response>\n'"

but my pipeline throws error

Job failed due to reason: com.microsoft.dataflow.Issues: DF-DSL-002 - Parameter stream has parsing errors Parameter(s) with errors: API_Response,<response success, <message key. Not honoring the datatype of parameter(s) could be one of the causes.

I tried to esape '' and '\n' before sending to dataflow....they couldnt be escaped. it has the same text even after trying that. Not able to find whats the root cause?

If I try the same text in dataflow debugging, I can see data preview working fine with no errors. The error appears while running the data flow.

Answer 1

Hello Santhi Dhanuskodi,

By design pipeline parameters add extra double and single quotes for string passed.

Workaround is to replace the quote in the string with blackslash single quote( ' ) when taking pipeline parameter in dataflow activity.

Please check and see if it resolves the issue.