Stringify Json

[Andreas]

How can I use pabbly connect to stringify a json and store the string in a cell in a google sheet?

 

[PabblyMember3]

You can disable the simple response option of the step where you are receiving the data. That will give you a JSON array.

Then, you can make use of JSON Extractor step to get the comma separated values as explained in this thread.

Chain json results as string

A module return a json payload with a X number of results, like values > 0 > 0 Apple values > 1 > 0 Orange values > 2 > 0 Pear and I need to generate a multi-line string like Apple Orange Pear Which is the best way?

forum.pabbly.com

 

[Andreas]

Thank you very much.
How can I save the json as a file in google drive?

 

[PabblyMember3]

Thank you very much.
How can I save the json as a file in google drive?

Well, I tried to check with different file types of Google Drive API listed here: https://developers.google.com/drive/api/v3/mime-types

But none of them worked for a JSON file. You need to manually create a JSON file in Google Drive.

 

[Andreas]

Thank you very much.
The file type is not important for me.
I just would like to save the json response that I get from an API to Google Drive or another cloud storage.
So if the file type is .txt or .xyz that's fine for me.
How can I do that?

 

[PabblyMember3]

Thank you very much.
The file type is not important for me.
I just would like to save the json response that I get from an API to Google Drive or another cloud storage.
So if the file type is .txt or .xyz that's fine for me.
How can I do that?

You can make use of Google Docs: Create a Blank Document and then, Append a Paragraph to a Document to the created docs file.

For each workflow execution, the Passed JSON data will get append in that doc file.

I hope you find the above solution helpful.