Error: Logic Apps Saving CSV file as Bytes in Blob Storage

Joseph Kozsuch 1 Reputation point
2020-11-16T15:57:03.373+00:00

I'm trying to automate the process of receiving a scheduled email with an attached csv file and then overwriting the file in blob storage. However, the file is saved a json with bytes, not csv.

logic app design:
40146-logic-app.jpg

What is saved:
40078-bytes.jpg

Thanks

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,996 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Mike Urnun 9,786 Reputation points Microsoft Employee
    2020-11-17T02:40:36.967+00:00

    Hello @Joseph Kozsuch - Before creating the blob, could you try using the Parse JSON action to extract the value of contentBytes and then base64 decode it? The decoded value should then be passed in to your blob content.

    0 comments No comments

  2. Joseph Kozsuch 1 Reputation point
    2020-11-17T16:47:24.763+00:00

    @Mike Urnun Thank you. I was able to parse the JSON. However, I have no background of using workflow to reference the json content and then decode it. Where would I find info to do this?

    0 comments No comments

  3. Joseph Kozsuch 1 Reputation point
    2020-11-17T18:36:05.157+00:00

    I received the answer from Stack overflow.

    0 comments No comments