Issue with ‘Scheduled Refresh’ for api calls

Hi Anonymous  and all:Thanks a lot for your response. I tried to follow the steps you mentioned. I am not sure what to do at the last step you mentioned: 

Add a new column to the current table and use the connector function to invoke data based on current id: (use id column name as a parameter in the connector)

    #"Added Custom" = Table.AddColumn(#"Converted to Table", "Source", each Json.Document(Web.Contents("https://api.xyz.com/natgas/events/v1/notices/details?ids=" & [NoticeId] & "&format=json", [Headers=[#"Gen-Api-Key"="……"]])))

I selected ‘Add Column’-> ‘Custom Column’-> then copy-pasted the code in ‘notice_detail’ function in the ‘Custom column formula’.

 After that I get a new Column, ‘Custom’ with ‘Function’ in each cell for different ids in the table. Not sure what to do now?

The code from advanced editor [in blue is similar to your code]

-----------------------------------

let

    Source = Json.Document(Web.Contents("https://api.xyz.com/",

    [

        RelativePath="natgas/events/v1/notices",

        Query=

        [

            priorities="critical",

            limit="50",

            offset="0",

            format="json"

        ]

        ,

        Headers=[

            #"Gen-Api-Key"="......."

            ]

        ]

        )),

    data = Source[data],

    #"Converted to Table" = Table.FromList(data, Splitter.SplitByNothing(), null, null, ExtraValues.Error),

    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"id", "pipelineName", "priority", "type", "subject", "postDate", "effDate", "endDate"}, {"id", "pipelineName", "priority", "type", "subject", "postDate", "effDate", "endDate"}),

    id1 = #"Expanded Column1"[id],

    #"Converted to Table1" = Table.FromList(id1, Splitter.SplitByNothing(), null, null, ExtraValues.Error),

    #"Added Custom" = Table.AddColumn(#"Converted to Table1", "Custom", each (NoticeId as number) => let

        Source = Json.Document(Web.Contents("https://api.xyz.com/natgas/events/v1/notices/details?ids=" & Number.ToText(NoticeId) & "&format=json", [Headers=[#"Gen-Api-Key"="......"]])),

        #"Converted to Table" = Record.ToTable(Source),

        #"Expanded Value" = Table.ExpandListColumn(#"Converted to Table", "Value"),

        #"Expanded Value1" = Table.ExpandRecordColumn(#"Expanded Value", "Value", {"id", "pipelineName", "pipelineId", "priorNoticeIdentifierId", "noticeIdentifierId", "priority", "type", "status", "subject", "body", "postDate", "effDate", "endDate", "insertDate"}, {"id", "pipelineName", "pipelineId", "priorNoticeIdentifierId", "noticeIdentifierId", "priority", "type", "status", "subject", "body", "postDate", "effDate", "endDate", "insertDate"})

    in

        #"Expanded Value1")

in

    #"Added Custom"

---------------------------------------------------

Would really appreciate any help on this. Best, Sohana