Forum Discussion

chonchar's avatar
chonchar
Helper V
2 years ago
Solved

New table based on iterative API calls

Hello! I have imported a table that is based on a CSV file. It is called table 1. In table 1, there is an "ID" column that needs to be referenced in an API call. Table 1 is below:    I am abl...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    chonchar here are quick steps:

     

    - click advanced editor of table 2 and get the copy of the M code

    - start new blank query, click advanced editor and type

    (id as text) =>
    and after this paste the M code 

     

    Save and close and you have M function with Is as parameter

parry2k's avatar
parry2k
Super User
2 years ago

chonchar  Check my original reply

 

once it is done, add new column in table 1 and call function (created in step 1) with id as parameter. You will get a table returned from the function and the last step is to expand this new column. This will do it.

  • chonchar's avatar
    chonchar
    Helper V
    2 years ago

    parry2k I am so close. So, I have this:

    But once I open that table, it is only creating the ID from the original M. 

     

     

    What ID Value goes here, or the column name?

    • chonchar's avatar
      chonchar
      Helper V
      2 years ago

      parry2k Does this look correct?