Forum Discussion
Write data from Web connector to lakehouse table
Solved.
RelativePath for Web activity starts with slash, but relative path in COPY activity doesn't start with slash. That's why it said NOT FOUND
Hello amaaiia
Save the output of the Web Activity as a variable:
• Use a Set Variable Activity after the Web Activity.
• Assign the output of the Web Activity to a variable using dynamic content, such as:
@activity('WebActivityName').output
In the Copy Activity settings:
• Source Tab:
• Select “Dynamic Content” as your source type. @variables('webData')
• Map it to the variable containing your JSON data.
When I set connection as variable content, it asks me in Source to select a lakehouse table. The source shouldn't be a lakehouse table but the content of the variable itself.
Use dynamic content optipn from the dropdown and set @variables('webData')
If you see the screenshot, this is what I've done
Use dynamic content optipn from the dropdown and set @variables('webData')