Multiple API URL

[KimRexh]

Hi!
I have 4 URLS that I want to get data from, and the 1st url does always contain data but not the 3 other ones. Sometimes they have data and sometimes not.

So Im wondering if its possible to add all 4 api urls in one query and "Skip" if callout does not contain data?

Setup today is that I get an error "could not find column..." When the other urls dont have data.

How can I solve this?

Thanks in advance

[v-jingzhang · Accepted solution]

Hi @KimRexh 

Another method is that you can create an empty table with only column names which are the same as columns from that API. Then append this empty table with the table queried from API. When API doesn't return any data, the table after appending is still an empty table with column names. It will not return error "could not find column..." because it has that column although there is no data there. 

let
    Source = APItable, 
    emptyTable = #table({"Name","ID","Date"},{}),
    #"Appended Query" = Table.Combine({Source, emptyTable})
in
    #"Appended Query"

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[mahoneypat]

You can create a one-column table with your 4 urls in each row, and then add

= try Web.Contents([URLcolumn]) otherwise null

in a custom column. You can then filter out the null rows and then expand your content.

Pat