What it does
Copies records from one web app to another through their APIs, field by field: it reads each page of records from the source (page=1, 2, … until a page is empty) and sends each one to the destination. Change the field mapping in the “Send” step's body (each source field is {{rec_<field>}}, e.g. {{rec_email}}). Start with Dry run = yes to see what would be sent. Records moved in an earlier run are skipped, so it can resume where it stopped.
How it works
- Repeats page after page
- Decides what to do next
- Calls the service's API
- Goes through each item
- Adds rows to your sheet
All 26 steps (as they appear in the app)
- moved = 0
- Repeat ×{{max_pages}} (9 steps)
- _sep = ?
- If source_url contains ?
- _sep = &
- _url = {{source_url}}
- If page_param not empty
- _url = {{source_url}}{{_sep}}{{page_param}}={{i}}
- GET {{_url}}
- If page_param empty
- _done = yes
- If _page matches ^\s*(\[\s*\]|null)?\s*$
- _done = yes
- For each rec in {{_page}} (1 steps)
- If dry_run equals yes
- Add row: record, result, name, email
- _key = {{rec_id}}
- If _key seen in past runs
- Add row: record, result
- {{dest_method}} {{dest_url}}
- If _status matches ^2
- moved = {{moved|0}} + 1
- Add row: record, result, status
- Add row: record, result, status, reply
- Count {{_key}} as new next run
- Pause 0.5s
Get this template
1. Download Develofly Autopilot: free, for Ubuntu and other Linux desktops.
Download Develofly Autopilot2. The app comes with every template, so this one is already in your library. Click below to open it (or find it under Templates).
Open in AutopilotWhat you need
- An API key for the service it uses
You fill in: Source: records address, Source: page number parameter, Source: headers, Source: where the list is in the answer, Destination: create address, Destination: method, Destination: headers, Most pages, Dry run (send nothing).
Make it yours
Every step is editable in the app: change the site, the columns, the schedule, or chain it with other bots. Run it once, on a schedule, or sell it as your own bot.