Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

API call through no numeric parameters

Hello. I have a problem working wirth API.   I've read many post, but can't find a solution to my problem.   I need to obtain information fron different APIs, but get error.   This is what i'm...
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    HI Anonymous,

    I'd like to suggest you create a blank query table to reference the 'Proyects' table, then you can add a custom column to invoke custom function based on each 'ID Proyects':

    let
    Source = Proyects,
    AddColumn =
        Table.AddColumn(
            Source,
            "Custom",
            each query1([ID_Proyects])
        )
in
    AddColumn

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI Anonymous,

I'd like to suggest you create a blank query table to reference the 'Proyects' table, then you can add a custom column to invoke custom function based on each 'ID Proyects':

let
    Source = Proyects,
    AddColumn =
        Table.AddColumn(
            Source,
            "Custom",
            each query1([ID_Proyects])
        )
in
    AddColumn

Regards,

Xiaoxin Sheng