ADF Bad Request upon complex variable

Question

ADF Bad Request upon complex variable

Samuel Janoska 1

Hi,

I'm using a pipeline in ADF and the pipeline Copy data activity us using a rather complicated expression for FilePath. It is dynamic content, which includes concat, substring, length, sub functions. After I click 'Debug', I'm receiving the 'BadRequest' notification with no option to find out what's wrong.

I have used the expressions separately under 'Sink' in Copy data activity, then as a variable. None of these worked.

The content works with expression received from a notebook - this is usually not an issue with other pipes.

I made sure the content is not wrong by testing it in another environment, modified in appropriate language and I received the result I expected.

Please help.

Samuel Janoska 1 Reputation point

2021-06-25T09:20:28.573+00:00

I have meanwhile found out, that ADF does not work well with nested statements. I decided to use multiple pipes and 'trigger pipes' above them. I'm using more variables and parameters, and, since this is a one-time project, fixed lengths at some points instead of length() function.
KranthiPakala-MSFT 46,827 Reputation points Moderator

2021-06-28T20:18:34.597+00:00

Hi @Samuel Janoska ,

Thanks for reaching out and using Microsoft Q&A forum.

Apologies for the delayed response and thank you for sharing the your workaround details. In case if you still need assistance on this query, please do share few additional details about your dynamic expression along with a sample so that we can better assist on it.

Looking forward to your confirmation.

Thank you
KranthiPakala-MSFT 46,827 Reputation points Moderator

2021-06-29T20:07:10.337+00:00

Hi @Samuel Janoska ,

Just wanted to check if you still need assistance on this query?

Thanks