Unanswered

Flow Twitter to Azure Blob as JSON file - Help

(0) Share

Report

Posted on by Community Power Pla...

Want to create a flow to create a BLOB file in JSON format for every tweet that contains a hashtag.

I've built the container in Azure Blob, connected successfully. I've picked: twitterID as the blog file name. I want tweetedBy and tweetText as the JSON file contents.

It works, but the files are in text with no formatting at all. Worse, they have /n or line breaks. A mess.

I figured the twitter input would be serialized as JSON and thusly the Azure blob output would then be JSON.

No? What am i doing wrong?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

v-monli-msft on at

Like (0)

Report

Reply:

Hi Evogelpohl,

Is the trigger of this flow “when a new tweet is posted”? If so, you could try to change another trigger to have a test, just to see if this is only happening to tweet parameter.

In addition, is your flow one like below?

Regards,
Mona Li

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@v-monli-msft Thanks. Yes, your picture describes exactly what I'm doing - that is: trigger on tweet, action; write blob to Azure blob storage. The only small difference is that I'm writing to a \Tweets folder in my blob container.

The Flow works fine. The blob file gets written in the \Tweets folder upon each tweet.

The problem is that the blob file is not in JSON format. It's in TXT, with no separation between TweetedBy and TweetText. It has carriage returns.

When I extract my blobs from the azure storage container, it's essentially unusable, jumbled mess.

It seems Flow is missing a "how to format/serialize output?" feature.

Eric.

Was this reply helpful? Yes No