- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @frithjof_v, Thanks for the reply.
I read the blog and used the relative path and yes it worked. Thanks
Regards
Fazil M
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
06-13-2024 10:42 AM | |||
06-13-2024 10:33 AM | |||
01-19-2024 10:15 AM | |||
08-21-2024 09:43 AM | |||
10-17-2024 10:53 AM |
User | Count |
---|---|
3 | |
2 | |
2 | |
1 | |
1 |