Azure Logic App: Create CSV File in Blob

Question

I am having a problem updating a csv file in my blob. I have an existing file inside my blob which is a CSV file, and when I press the download button it will automatically download the file to my machine.

Now I already created a Logic App that will update the csv file. When I run the trigger of the app, it updates the file but when I press download, it opens up a new tab where the csv file will be displayed.

I want it the way like the original when I press download it download the file to my machine.

Any help will do or verification if this is possible.

I already tried "compose" and "create to csv" but this way it will not store it to a blob.

Are you using the get blob content action ? If you click on show advanced options you will see a Infer Content Type field. Set it to No and it should work. — Thomas
– Thomas, Commented May 8, 2018 at 9:40
Because you content-type is text/plain, you need to set it as application/octet-stream. — Joey Cai
– Joey Cai, Commented May 8, 2018 at 10:19

Joey Cai · Accepted Answer · 2018-05-10 01:30:56Z

2

As I have test, when you want to create a .csv file with "create blob" action in logic app, it will always get the same problem with you. Because the blob content is "text/plan" which will display in another tab to show.

So, I suggest that you could use azure function to create the blob. In azure function you could set:blob.Properties.ContentType = "application/octet-stream";

Here is the create blob method in azure function:

    storageAccount = CloudStorageAccount.Parse(connectionString);

    client = storageAccount.CreateCloudBlobClient();

    container = client.GetContainerReference("data");

    await container.CreateIfNotExistsAsync();

    blob = container.GetBlockBlobReference(name);
    blob.Properties.ContentType = "application/octet-stream";

    using (Stream stream = new MemoryStream(Encoding.UTF8.GetBytes(data)))
    {
        await blob.UploadFromStreamAsync(stream);
    }

For more detailed code, you could refer to this article. After following that, you could download your blob in your local machine.

Note: when you create the azure function action in logic app, it will show error. Just delete Appsetting of "AzureWebJobsSecretStorageType" to "blob".

edited May 10, 2018 at 1:30

answered May 9, 2018 at 10:35

Joey Cai

20.2k1 gold badge25 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Rey Norbert Besmonte Over a year ago

thanks. Took me a few days to understand but I got it. :)

Collectives™ on Stack Overflow

Azure Logic App: Create CSV File in Blob

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related