Help with Data Output Syntax

#1

I am stuck. I am trying to search a google sheet for the following user id’s but I cannot get the search value syntax right. Could someone help?
{
“users”: [
{
“user”: {
“id”: 9862,
“email”: "johndoe@gmail.com",
“first_name”: “John”,
“last_name”: “Doe”,
“dot_id”: “”,
“phone”: “(555) 555-5555”,
“phone_ext”: null,
“time_zone”: null,
“role”: “admin”,
“status”: “active”,
“created_at”: “2015-04-20T16:22:41Z”,
“updated_at”: “2017-03-01T21:23:15.079045Z”
}
},
{
“user”: {
“id”: 341,
“email”: "joe@doe.com",
“first_name”: “Joe”,
“last_name”: “Doe”,
“dot_id”: null,
“phone”: “(555) 123-45678”,
“phone_ext”: “”,
“time_zone”: null,
“role”: “admin”,
“status”: “active”,
“created_at”: “2016-11-11T20:26:00Z”,
“updated_at”: “2017-03-02T03:11:57.569809Z”
}
etc…

(John Jackson) #2

You mean the data output format right, the key?

That would be:

users__0__user__id
users__1__user__id
#3

John, that worked.

One other question, how could i have Flowxo repeat the google search for each of the users above? I would like to search google sheets for user 9862, perform some actions, then repeat the process for user 341 and so on. The number of users return will vary.

(John Jackson) #4

I missed this reply, sorry!

We now have a Goto a Label method that allows you to repeat sections of a flow. With this, you may be able to construct the behaviour you’re after.

There’s a good article explaining how it works here: