question

SamuelJanoska-4243 avatar image
0 Votes"
SamuelJanoska-4243 asked KranthiPakala-MSFT commented

ADF Bad Request upon complex variable

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.

azure-data-factory
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·

Hi @samueljanoska-4243,

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

0 Votes 0 ·

Hi @samueljanoska-4243,

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

Thanks

0 Votes 0 ·

0 Answers