Forum Discussion

M0hamedFazil's avatar
M0hamedFazil
Icon for Helper II rankHelper II
1 year ago
Solved

New connection Creation

Hi all I'm retrieving and API that give me an export ID and I want to check that whether the API is done processing or not and once processing is done I'll store the file to my warehouse using dat...
dataflow
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi M0hamedFazil 

 

Whether you can add a retry mechanism

 

export_id = GetExportid[id],

geturl = (group_id, report_id, access_token, export_id, connection) =>
let
    check = CheckStatus(group_id, report_id, access_token, export_id, connection),
    status = check[status],

    file_url = if status = "Succeeded" then
        check[resourceLocation]
    else
        Function.InvokeAfter(() => @geturl(group_id, report_id, access_token, export_id, connection), #duration(0, 0, 0, 30))
in
    file_url,

// Initialize connection once and pass it to the function
connection = InitializeConnection(),
file_loc = geturl(group_id, report_id, access_token, export_id, connection)

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

M0hamedFazil's avatar
M0hamedFazil
Icon for Helper II rankHelper II
1 year ago

hi Anonymous, Thanks for the reply

I have solved this and I was facing a problem where the flow started running and I think it sturk at some point. Can you please tell how to initiate the connection, How the function looks like?. I'll try initiate the connection and update with that here. Thanks 

Regards
Fazil M