Hi everyone. I have an issue parsing a response from Firebase. I have taxi drivers who might miss jobs on the app while offline. When they return I want to look back through the jobs of the day to check the status of each one. If any show a status of new or declined I want to take some action and alert the driver.
The response I am getting appears to be a list of jobs and each job has a number of properties within it, including status and a jobID. So in the file attached here I get a response of 10 jobs with each job having 17 to 20 properties. Is this a list within a list or a flat file? I cant work it out.
I am currently using a count with loop to play with just a 3 or 4 results so things are more manageable. Does anyone know how to parse the attached JSON file to get the results I am after?
My rather pathetic attempts at blocking this are included here. I have tried using Create Object from JSON and Json from Object as well.
response.txt (5.0 KB)