SarahS.89561 (Customer) asked a question.
I need to be able to extract the sheetId, title, rowCount and columnCount from the below payload and can't see a way to do this in Workflows
We use cookies to provide the best website experience and to help understand marketing efforts. We may also share data with ad partners to reach potential customers across the web. To learn more, visit our Privacy Policy. Click here for Your Privacy Choices. You may also opt out of this sharing by signaling your preference via GPC, applicable only to the browser signaling the opt-out.
More information
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work. These cookies do not store any personally identifiable information.
These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
Select All
We use cookies to provide the best website experience and to help understand marketing efforts. We may also share data with ad partners to reach potential customers across the web. To learn more, visit our Privacy Policy. Click here for Your Privacy Choices. You may also opt out of this sharing by signaling your preference via GPC, applicable only to the browser signaling the opt-out.
More information
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work. These cookies do not store any personally identifiable information.
These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
Select All
Forgot to add the payload
{
"sheets": [
{
"properties": {
"sheetId": 0,
"title": "Sheet1",
"index": 0,
"sheetType": "GRID",
"gridProperties": {
"rowCount": 1000,
"columnCount": 26
}
}
},
{
"properties": {
"sheetId": 317732887,
"title": "Sheet2",
"index": 1,
"sheetType": "GRID",
"gridProperties": {
"rowCount": 1000,
"columnCount": 26
}
}
},
{
"properties": {
"sheetId": 2125125274,
"title": "Sheet3",
"index": 2,
"sheetType": "GRID",
"gridProperties": {
"rowCount": 1000,
"columnCount": 26
}
}
},
{
"properties": {
"sheetId": 144976084,
"title": "Sheet4",
"index": 3,
"sheetType": "GRID",
"gridProperties": {
"rowCount": 1000,
"columnCount": 26
}
}
},
{
"properties": {
"sheetId": 1179906118,
"title": "Sheet5",
"index": 4,
"sheetType": "GRID",
"gridProperties": {
"rowCount": 1000,
"columnCount": 26
}
}
},
{
"properties": {
"sheetId": 1615383701,
"title": "Sheet6",
"index": 5,
"sheetType": "GRID",
"gridProperties": {
"rowCount": 1000,
"columnCount": 26
}
}
},
{
"properties": {
"sheetId": 561243345,
"title": "Sheet7",
"index": 6,
"sheetType": "GRID",
"gridProperties": {
"rowCount": 1000,
"columnCount": 26
}
}
}
]
}
Okay, so the payload you have provided as an example is an Object named "Sheets" containing a list of objects.
Each of these objects contain a top level object named properties which then contains multiple key:value pairs and so on.
To access this data you really need to push it into a foreach so you can iterate over each object. Here is an example:
Flow1:
That is amazing, thank you so much. Can I ask one more thing, at the start of the flow I'm querying a table which contains spreadsheet ID's that I want to query, I need to know which sheets belong to which spreadsheet if that makes sense, how do I pass the spreadsheet ID with the payload so I can write it to a table for later use
Hi Sarah,
Not really understanding the latest ask here. In your previous example it appears you have an ID and Title combined for each object. Those objects are then being processed out individual in a Helper flow (from my example). If you wanted to "Store them for later use" I would suggest a Workflows table. You could take the outputs from the Object - Get Multiple to construct it. This would allow you to query the ID and return the title value in "later flows".
If you mean the "Entire example payload" and you currently "Know" the Spreadsheet ID you are talking about could be passed down as an additional option in the helper flow (So in addition to the one I added called Input). On the helper you could create another "input" called SpreadsheetID as a text field and save the flow. Then back on the Parent flow re-select the Helper flow giving you the new input field on the For Each card which can accept a static or dynamic value.
Thanks Tim
That's really helpful
Hi @SarahS.89561 (Customer) - I want to publish a how-to guide based on your questions. Can I reuse your JSON object in a blog post?
Hi @MaxKatz (Okta) - Of course, help yourself