TeamDesk Knowledge Base & Support

   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

[{"DeviceName":"Device 1",

{"DeviceName":"Device 2",

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 Nelson
Date Created
7/1/2019 4:57:06 PM
Date Updated
7/10/2019 9:18:26 AM
Philipp Matuschka (MMB) 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
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.
Back to Search Results