Forum Discussion

KimRexh's avatar
KimRexh
Regular Visitor
4 years ago
Solved

Multiple API URL

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...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    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.

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

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.