Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
amaaiia
Super User
Super User

Write data from Web connector to lakehouse table

‎02-04-2025 08:17 AM

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?

Message 1 of 8
743 Views
0
1 ACCEPTED SOLUTION
amaaiia
Super User
Super User

‎02-05-2025 03:40 AM

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

Message 8 of 8
659 Views
7 REPLIES 7
amaaiia
Super User
Super User

‎02-05-2025 03:40 AM

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

Message 8 of 8
660 Views
nilendraFabric
Super User
Super User

‎02-04-2025 10:42 AM

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.

Message 2 of 8
713 Views
0
amaaiia
Super User
Super User
In response to nilendraFabric

‎02-04-2025 11:28 PM

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

 

Message 3 of 8
698 Views
0
nilendraFabric
Super User
Super User
In response to amaaiia

‎02-05-2025 12:45 AM

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

nilendraFabric_1-1738745064795.png

 

Message 7 of 8
689 Views
0
nilendraFabric
Super User
Super User
In response to amaaiia

‎02-05-2025 12:45 AM

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

nilendraFabric_1-1738745064795.png

 

Message 4 of 8
689 Views
0
amaaiia
Super User
Super User
In response to nilendraFabric

‎02-05-2025 03:39 AM

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

Message 5 of 8
659 Views
0
nilendraFabric
Super User
Super User
In response to amaaiia

‎02-05-2025 03:53 AM

No screenshots visible 

Message 6 of 8
651 Views
0

Helpful resources

Announcements
August Fabric Update Carousel

Fabric Monthly Update - August 2025

Check out the August 2025 Fabric update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

View All
Top Kudoed Authors
View All