Export API

​

Supported objects

• Main Scenario Model URL example: https://app.runway.com/skynet/submodel/afd94c7e-1e7f-4e55-b99a-472aa5a43cd9
• Scenario Model URL example: https://app.runway.com/skynet/proposal/445f8fea-df2a-49cb-9cce-f805be588137/submodel/afd94c7e-1e7f-4e55-b99a-472aa5a43cd9
• Main Scenario Database example: https://app.runway.com/skynet/page/5fb5f2a6-7a13-4085-a89c-86e2da66a17c
• Scenario Database URL example: https://app.runway.com/skynet/proposal/445f8fea-df2a-49cb-9cce-f805be588137/page/5fb5f2a6-7a13-4085-a89c-86e2da66a17c

​

Guide

1. Log into Runway > Settings (top right) > API
2. Obtain your API secret, this will be used as a Bearer Token in the header of your request.
   1. Authorization: Bearer <your bearer token here>
3. Format your API endpoint:
   1. Grab the URL of the Database or Model you want to pull data from
   2. Replace “app.runway.com/org-url” with “api.runway.com/api”
      • https://app.runway.com/skynet/submodel/afd94c7e-1e7f-4e55-b99a-472aa5a43cd9
      • becomes
      • https://api.runway.com/api/submodel/afd94c7e-1e7f-4e55-b99a-472aa5a43cd9
4. HTTP method set to GET

​

Limitations

• If you have a database with multiple drivers, Runway will only show the time series data that is currently expanded on that page.
• If you want multiple drivers from a database, shape a new database off that existing database and pull from separate databases.
• The time period pulled is limited to the filters applied on the database and model.
• Formulas cannot be exported at this time.
• The exported data is in csv format only

​

Example Runway > Google Sheet Integration

• Video Guide
• Here’s a sample app script to export a model
  • Be sure to replace the following:
    • “PUT API ENDPOINT HERE” with your https://api.runway.com/api…
    • “PUT TOKEN HERE” with your token from the Runway settings menu
    • “PUT SHEET TAB NAME HERE” with the name of the tab you want to put the data in
      Copy

      Ask AI

      function importRunwayData() {
        var url = "PUT API ENDPOINT HERE";
        var token = "PUT TOKEN HERE";
      
        // Call the API
        var response = UrlFetchApp.fetch(url, {
          method: "get",
          headers: {
            "Authorization": "Bearer " + token,
            "Accept": "application/json"
          },
          muteHttpExceptions: true
        });
      
        // Parse JSON
        var data = JSON.parse(response.getContentText());
        var csvString = data.contents;
      
        // Clean BOM if present
        csvString = csvString.replace(/^\uFEFF/, "");
      
        // Parse the entire CSV string at once
        var rows = Utilities.parseCsv(csvString);
      
        // Get the "Runway import" tab (create if missing)
        var ss = SpreadsheetApp.getActiveSpreadsheet();
        var sheet = ss.getSheetByName("PUT SHEET TAB NAME HERE");
        if (!sheet) {
          sheet = ss.insertSheet("PUT SHEET TAB NAME HERE");
        }
      
        // Clear and write values
        sheet.clearContents();
        sheet.getRange(1, 1, rows.length, rows[0].length).setValues(rows);
      }