How to get the content of .csv file from azure blob storage in logic app

Question

How to get the content of .csv file from azure blob storage in logic app

Ananya Dixith 61

Hi,

I need to get the content of .csv file present in azure blob container

I used Get blob content action but I'm facing error.

"message": "The specified resource name contains invalid characters

togetcontenofcsv

Before using get blob content I used list blobs action to automatically get .csv files.

getblobcontent

get blob content should automatically identify .csv file and get its content.

I have added a condition to automatically identify .csv file its working,

but when I gave Displayname from previous list blob action to get blob content its showing error.

Pls anyone provide me the solution for this error

Thank you

Amrinder Singh 5,870 Reputation points Microsoft Employee

2024-03-11T14:45:20.3+00:00

Hi @Ananya Dixith - Thanks for reaching out. Based on the exception it appears that the request to storage is somehow malformed and hence resulting into bad request.

Can you share the complete exception stack/ error message?
Ananya Dixith 61 Reputation points

2024-03-12T04:18:50.9266667+00:00

Hi @Anonymous The error which is displaying is as follows

{ "status": 400, "message": "The specifed resource name contains invalid characters.\r\nclientRequestId: 6acf1427-1d2f-46e5-b975-275549aacf11", "error": { "message": "The specifed resource name contains invalid characters." }, "source": "azureblob-je.azconn-je-001.p.azurewebsites.net" }

1 answer

Your answer

Amrinder Singh 5,870 Reputation points Microsoft Employee

2024-03-11T14:45:20.3+00:00

Hi @Ananya Dixith - Thanks for reaching out. Based on the exception it appears that the request to storage is somehow malformed and hence resulting into bad request.

Can you share the complete exception stack/ error message?
Ananya Dixith 61 Reputation points

2024-03-12T04:18:50.9266667+00:00

Hi @Anonymous The error which is displaying is as follows

{ "status": 400, "message": "The specifed resource name contains invalid characters.\r\nclientRequestId: 6acf1427-1d2f-46e5-b975-275549aacf11", "error": { "message": "The specifed resource name contains invalid characters." }, "source": "azureblob-je.azconn-je-001.p.azurewebsites.net" }

Answer 1

Hi @Ananya Dixith - The above doesn't provide much insight further and only points that somewhere the request is getting malformed or probably some URI.

Had it been any request ID (typically ending with 6 0's, it would have pointed to be failing on the storage however the source in exception pointing to some app endpoint which is confusing.

As you mentioned in the initial verbatim that while providing directly it works correctly so you can try debugging to see what the URL is being formed on the failing instance to compare with the working scenario.

The last resort will be to reach out the Logic App Support via a support case to take a closer look and help in further troubleshooting/resolution.

Kindly let me know for any further queries and will be glad to assist.

Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

Share via

How to get the content of .csv file from azure blob storage in logic app

1 answer

Your answer