How to pass values from lookup activity to Web activity in azure data factory

muhammad abubakar 0 Reputation points
2023-02-28T14:09:48.87+00:00

Hi,
I am attempting to refresh an Azure analysis using Azure Data Factory. When I use hard-coded values for the table name and partition name in the Web activity, the pipeline runs successfully.actitivity pass

When I use a For Each activity to iterate through a list of values and run the pipeline, the Web activity inside the For Each activity fails and I receive a "BadRequest" error with the message "Request body cannot be empty." I have attached two images of both cases for reference.

activity fail error


{"Type":"Full","CommitMode":"transactional","MaxParallelism":10,"RetryCount":2,"Objects": 
[{"table":"DIM_PRODUCT","partition":"Partition"}
]}
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,267 questions
{count} votes