Develofly Autopilot
Templates › Documents, Forms & Data Entry › App-to-app data migration mover

App-to-app data migration mover

Copy records between two web apps field by field.

Documents, Forms & Data Entry

Download the app, freeOpen in Autopilot

App-to-app data migration mover: what it does, step by step

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

  1. Repeats page after page
  2. Decides what to do next
  3. Calls the service's API
  4. Goes through each item
  5. Adds rows to your sheet
All 26 steps (as they appear in the app)
  1. moved = 0
  2. Repeat ×{{max_pages}} (9 steps)
  3. _sep = ?
  4. If source_url contains ?
  5. _sep = &
  6. _url = {{source_url}}
  7. If page_param not empty
  8. _url = {{source_url}}{{_sep}}{{page_param}}={{i}}
  9. GET {{_url}}
  10. If page_param empty
  11. _done = yes
  12. If _page matches ^\s*(\[\s*\]|null)?\s*$
  13. _done = yes
  14. For each rec in {{_page}} (1 steps)
  15. If dry_run equals yes
  16. Add row: record, result, name, email
  17. _key = {{rec_id}}
  18. If _key seen in past runs
  19. Add row: record, result
  20. {{dest_method}} {{dest_url}}
  21. If _status matches ^2
  22. moved = {{moved|0}} + 1
  23. Add row: record, result, status
  24. Add row: record, result, status, reply
  25. Count {{_key}} as new next run
  26. Pause 0.5s

Get this template

1. Download Develofly Autopilot: free, for Ubuntu and other Linux desktops.

Download Develofly Autopilot

2. 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 Autopilot

What 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.

More Documents, Forms & Data Entry templates

Form filler from a spreadsheetOne form submission per spreadsheet row.Screenshots of a list of pagesFull-page screenshots of a list of pages.PDF form fillerFill and save a PDF form from each row of a sheet.Statement / PDF downloaderSign in to several portals and download this month's statements.