Forum Discussion
How to create a conditional column from APIs using the values of a given column?
HI AnkitaChatterje,
My formula is custom function, please add blank query and open advanced editor to use my formula to replace.
After this steps, you can add new column on tables which contains id list, then use id column as parameter to invoke functions.
Sample steps:
Regards,
Xiaoxin Sheng
Hi AnkitaChatterje,
You can write a custom function to your queries, then add custom column on table who have 'user id' column and use this id as parameter to invoke custom function.
Sample funciton:
let
LoadData=(userKey as text) as table=>
let
Source= Record.ToTable(Json.Document(Web.Contents("Https://api.machinesense.com/api/mechine/"&userKey)))
in
Source
in
LoadData
Regards,
Xiaoxin Sheng
Hi,
Thanks for the suggestion. But can you kindly explain the steps that I need to incur while creating the custom column. I have tried creating a custom column using this approach, but I am getting an error.
QueryHere, I am entering a column name as "parameter". Example: #"TableName"[machine_id]
HI AnkitaChatterje,
My formula is custom function, please add blank query and open advanced editor to use my formula to replace.
After this steps, you can add new column on tables which contains id list, then use id column as parameter to invoke functions.
Sample steps:
Regards,
Xiaoxin Sheng