Stringify Json
Status: Closed · Asked by Andreas on · 0 views
How can I use pabbly connect to stringify a json and store the string in a cell in a google sheet?
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.
https://forum.pabbly.com/threads/chain-json-results-as-string.145/#post-566
Thank you very much.
How can I save the json as a file in google drive?
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.
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?
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.