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
Anonymous
Not applicable

Add API result to each row when adding a column using Invoke function

hello

 

I am trying to Invoke a function that is pulling data from an API. The function takes IDs from the table where I am adding the column.

 

Here is my function 

 

 

let
    Source =(ID_1, ID_2 as text) => let
           Source = each Json.Document(Web.Contents("https://fake.api.com/v3/rest/fake1/" & ID_1 & "/fake2/" & ID_2 & "/fake3?limit=1&offset=0" , [Headers=[Authorization= "Bearer myapikey"]])),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
    in      
    #"Converted to Table"
in
    Source

 

the table is like this

ID_1ID_2
6e9e7742-d651-44f6-b2a1-6d1edcd94ace17e61aba-19f1-49d6-a07c-aa0085b38b5f
c89f89b2-bfd6-4984-b672-ad3f20a1fb8ca4f06500-2a2a-4318-a9ab-bfeae705e7d3

 

I get this error message when invoking the function 

Expression.Error: We cannot convert a value of type Function to type List.
Details:
Value=[Function]

 

Thanks

Joe
Type=[Type]

1 ACCEPTED SOLUTION
Anonymous
Not applicable

By removing the "each" before  Json.Document helped it work 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

By removing the "each" before  Json.Document helped it work 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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