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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
paz
Regular Visitor

Web.Contents Query parameter - multiple parameters with same name

I am trying to run the following API call:
https://api.address.com/api/v1?code=xxxxxxxxxxxx&fields=CallerNumber&fields=Date&fields=NumberDialed
It runs fine in browser / postman

I want to use Web.Contents Query option, but since the API syntax requires me to precede each field with a separate "field=" clause, it gives me error:
Expression.Error: The name 'fields' is defined more than once.
Here is my PQ:
= Json.Document(Web.Contents("https://api.address.com/api/v1?code=xxxxxxxxxxxx",
[
Query= [
fields="CallerNumber",
fields="Date",
fields="NumberDialed"
]]))

I cannot use "fields=CallerNumber,Date,NumberDialed" syntax in API, only state "fields=" for each field
I tried

fields="CallerNumber&fields=Date&fields=NumberDialed" (I thought it would pass it as one string), but it didn't work

I do want to use Query option.

Any ideas?

3 REPLIES 3
evanK03
Regular Visitor

Please try using following syntax it worked for me:

fields={"FieldName1","FieldName2","FieldName3",...}

 

In your case it would be:

 

 

= Json.Document(Web.Contents("https://api.address.com/api/v1?code=xxxxxxxxxxxx",
[
Query= [
fields={"CallerNumber","Date","NumberDialed"}
]]))

 

 

v-xiaotang
Community Support
Community Support

HI  @paz 

Please check if this link help,

Solved: Web.Contents with complex Query parameter names - Microsoft Power BI Community

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

 

I did. I've checked like 30 google pages before opening this post, indluding the link you've sent.

I am asking for a specific case, which is not addressed there.

Can you help?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.