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

Join us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered

Reply
MOVC
Helper II
Helper II

API Request (Web Action) Relative Path Not Working

I have an API GET request working in Postman for testing:

 

[base url]/envelopes?count=750&from_date=2024-10-01&order_by=last_modified&include=recipients

 

When I set up a web request in Data Factory to do the same thing, I get an error message response:

 

{"errorCode":"INVALID_REQUEST_PARAMETER","message":"The request contained at least one invalid parameter. Invalid value for query string parameter 'from_date'"}

 

Looking at the activity inputs though there doesn't seem to be anything wrong:

 

{ "method": "GET", "headers": { "Authorization": "Bearer blahh" }, "httpRequestTimeout": "00:10:00", "relativeUrl": "envelopes?count=750&from_date=2024-10-01&order_by=last_modified&include=recipients" }

 

I've tried a few things like alternative date formatting and URL encoding but to no success. I can't really see what's going wrong here unless data factory is doing something to the relativeUrl after this. Any ideas? I believe this was working some time before christmas, I don't know if any changes to the platform have been made since.

 

EDIT:

 

Some further testing. I have another query which grabs user data which succeeds. However if I add in the relative path &additional_info=true, then the action fails. There must be some issue with handling this relative path.

 

EDIT2:

 

If I remove the relative path and include it in the full connection then it works as a work around. However this isn't acceptable as a solution as I need to be able to parametrise these optional items.

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Please follow the documentation. Use RelativePath and Query parameters. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-1

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

Please follow the documentation. Use RelativePath and Query parameters. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-1

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June FBC25 Carousel

Fabric Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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