Search API Connector Documentation

Print

Import / Export Configuration Files

Last Updated On
byAna
< Knowledge Base

Importing and exporting configuration files for the API Connector add-on for Google Sheets allows you to share or duplicate your requests by copying request configurations from one sheet to another. The request configuration includes API URLs, headers, and output options.

Please note: importing is available on all plans, but exporting is a pro feature; please upgrade to access.

Contents

Import File

To import a configuration file, please click on Add-ons > API Connector > Import/Export > Import File
import-export-img1

You will be prompted to select a configuration file to import. Note that this file must be a valid API Connector export file.
import-export-img2

All requests must have an output sheet, or they won’t be imported. If you’d like to automatically create these sheets during the import process, check the box saying ‘Automatically create new destination sheets’.
import-export-img3

Export File

To export a configuration file, please click Add-ons > API Connector > Import/Export > Export File.
import-export-img4

This will produce an export file modal. Click the “Download export file” link to download all your requests as a JSON file to your desktop.
import-export-img5

In some cases, Chrome may block the JSON file download as described here. Therefore, the export file will also be saved into the first tab of your sheet. To use that export file instead, open that tab and click File > Download > Tab Separated Values (the file will only be recognized if it uses tab-separated values).

import-export-img6

Either way, you can then import your request file into other Sheets to re-create your requests.

Tips and Troubleshooting

  • As noted above, all requests must have an associated sheet. Requests without a sheet will not be imported. This means that you can restrict which requests get imported by not creating sheets for them.
  • If you want to create an exact duplicate of an existing sheet, click File > Make a copy in your existing sheet, and then import the request file into the copy. If you instead want to duplicate only the request configurations without existing data, start with a fresh, empty worksheet, and tick the ‘Automatically create new destination sheets’ checkbox before importing.
  • If your sheet already has a request with the same name, new requests will be imported in with a ‘_2’ appended to the name.

Leave a Comment