Reply
M0hamedFazil
Helper I
Helper I

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 dataflow gen2. I have written an recursive function for that. For each new export ID it'll be included to the API url. Now my problem for each new export ID it creates new connection which hindrances my flow. Can I avoid saving the connection?


M0hamedFazil_0-1729663178509.png



This is the error that pops up each time a new ID is created. I want to automate this using pipeline. If this pops up for each run I can't do that. I'm including the function where this error pops up

 

export_id = GetExportid[id],

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

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



Can anyone help me on this, Thanks in advance

regards
Fazil M

1 ACCEPTED SOLUTION
4 REPLIES 4
v-nuoc-msft
Community Support
Community Support

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.

hi @v-nuoc-msft, 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 

frithjof_v
Community Champion
Community Champion

Hi @frithjof_v, Thanks for the reply.

I read the blog and used the relative path and yes it worked. Thanks

Regards
Fazil M


avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)