Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Get API with response of several records
Ok so working with a API trying to do a couple things. My Fleet GPS provider has a API that I can get data out of. It is very basic but it is a start. currently they don't have any webhook capability they only allow me to Get Data from them. So no problem that I can setup a call URL to retrieve current location data. Here is where my problem starts. I would love to send a call URL every 2 minutes to get locations of all devices. 2 issues with that first short of creating a periodic trigger every 2 minutes and having 240 triggers created to have current data and second creating 1 action for each of my GPS devices I haven't figured out a good way to go get the data.

My next thought was to find a new gps provider that has post capabilities and have it post to a GPS table inside my DB. I have found one but my problem is the data they provide is post for all my devices so it output looks something like this

{"Data":
[{"DeviceName":"Device 1",
"DeviceID":"10000001",
"Date":"2019-07-01T16:01:24-05:00",
"Latitude":32.94660,
"Longitude":-97.02740,
"Type":"GPS",
"Speed(mph)":59,
"Speed(km/h)":95,
"Direction":135,
"Altitude(ft)":603,
"Altitude(m)":184,
"Accuracy":5},

{"DeviceName":"Device 2",
"DeviceID":"10000002",
"Date":"2019-07-01T16:01:24-05:00",
"Latitude":32.84687,
"Longitude":-96.71690,
"Type":"GPS",
"Speed(mph)":4,
"Speed(km/h)":6,
"Direction":0,
"Altitude(ft)":603,
"Altitude(m)":184,
"Accuracy":5}
]
}

What I need to know is if there is a way for TeamDesk to take that post and create multiple records inside my GPS table? if there is I haven't figured it out.

Mike
ID
1293
Category
Integration/API
Author

Mike Nelson
Date Created
7/1/2019 4:57:06 PM
Date Updated
7/10/2019 9:18:26 AM
Comments
Philipp Matuschka 7/3/2019 3:08:13 AM
Hi Mike

I've never tried this, but what if, instead of a periodic trigger. you used a time dependent trigger, which when it was finised updated some date field in a record, which therefore caused the same trigger to run again a few minutes later. You wouldn't have control over how many minutes - depending on how loaded the system is time dependent triggers seem to take from 1 to 20 minutes to run. But you also wouldn't have to write and manage 240 periodic triggers.

Worth a try?
Admin Account 7/6/2019 3:06:13 PM
I have done this already to a degree, but it was fairly annoying to set up. I believe it can be done via Call-URL and formulas to parse the data. You could also look into using zapier as it allows for more ways to manipulate data.
Nick Ashcroft 7/10/2019 9:18:26 AM
I never used Zapier but have been experimenting Flow Analytics https://flow-analytics.com
This has a pretty powerful automation framework.
The community edition is free to play about with (requires some chrome plugins)

maybe worth a look. Takes a while to get your head around the different workflow actions and approaches but the (free) chat support is very responsive.

I have no affiliation with this company/product but its proving great for integrating with teamdesk and other applications for upserting data, cleaning up data (bulk delete using loops), comparing data sets etc.
Feedback
Back to Search Results