Unanswered

Flow Twitter to Azure Blob as JSON file - Help

Like (0) Share

Report

Posted on 22 Oct 2016 01:20:26 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?

All responses (2)

Answers (0)

Community Power Pla... on 24 Oct 2016 at 14:08:36

Like (0)

Report

Re: Flow Twitter to Azure Blob as JSON file - Help

@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.
v-monli-msft on 24 Oct 2016 at 06:56:54

Like (0)

Report

Re: Flow Twitter to Azure Blob as JSON file - Help

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