Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
amaaiia
Super User
Super User

Write data from Web connector to lakehouse table

Hi,

I have one Web Connector connected to a web service.

When I cerate a Web activity in a Data Pipeline and I use this connection, it retrieves me data as follows (json objects list):

amaaiia_1-1738685629251.png

amaaiia_2-1738685673541.png

 

Where each object should be a row in the table.

 

If I try to use the same conneciton in COPY activity, I get an error in the preview of the data:

amaaiia_4-1738685695950.png

Rest call failed with client error, status code 404 NotFound, please check your activity settings.
Response: <html>
<head><title>404 Not Found</title></head>
<body>
<center><h1>404 Not Found</h1></center>
<hr><center>nginx</center>
</body>
</html>

 

Any ideas of how to ingest data from web connector into lakehouse table?

1 ACCEPTED SOLUTION
amaaiia
Super User
Super User

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

View solution in original post

7 REPLIES 7
amaaiia
Super User
Super User

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

nilendraFabric
Super User
Super User

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.

 

amaaiia_0-1738740460009.png

 

Use dynamic content optipn from the dropdown and set @variables('webData')

nilendraFabric_1-1738745064795.png

 

Use dynamic content optipn from the dropdown and set @variables('webData')

nilendraFabric_1-1738745064795.png

 

If you see the screenshot, this is what I've done

No screenshots visible 

Helpful resources

Announcements
August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.