Download

Once a submission is shared, authorized parties can securely download the submission contents using a time-limited access token.

This token grants temporary, read-only access and automatically expires after a predefined period, ensuring secure and controlled distribution of sensitive information.

The token can be used as a Bearer token in the Authorization header to retrieve submission data via a standard GET request over HTTPS.

This allows integration with any system or tool capable of making HTTPS requests. Below are examples using:

  • Microsoft Excel (Power Query)
  • Standard GET requests

Download to Excel

Once you've been shared access to a submission, you can download its contents to Excel through the following steps:

1
Click Download

Click the Download button in either the Forms or Grid section of the desired submission.

2
Copy Power Query Script

Click the Generate Token button icon. A token should appear in the input field. Click the Copy as Power Query button. Your clipboard should now contain a script similar to the following:

let
    Source = Json.Document(
        Web.Contents(
            "https://www.boundplatform.ca/api/router/submission-token/", 
            [
                Headers = [
                    Authorization = "Bearer YOUR_TOKEN_WILL_BE_HERE"
                ]
            ]
        )
    ),
in
    Source
3
Paste Query in the Power Query Advanced Editor

In Excel, click Data > Get Data > From Other Sources > Blank Query > Advanced Editor. Delete the text currently in the editor and paste the Power Query script in the editor. Click Done once complete.

4
Optional: Confirm Anonymous Content

If prompted with a Access Web Content window, choose Anonymous and click Save.

5
Done!

Your data should now be successfully loaded into the Power Query Editor. You can filter or transform the data using Power Query. Once properly transformed, click Close & Load to load the data to a new worksheet in your workbook.

Reuse Queries in Excel

You can reuse query steps for other submissions by parametrizing the token with which the submission is queried, and replacing it with a newly generated token to pull new data as follows:

1
Get New Token

Using a new submission, generate a new token and copy its value to your clipboard.

2
Parametrize the Token in Excel

In Excel, open the Power Query Editor and in the Parameters section, click Manage Parameters > New Parameter. Create a new parameter with the following details:

  • Name: Token
  • Description: (Optional)
  • Current Value: (Paste your newly generated token here)
3
Update the Query Source

Open Advanced Editor. Find the line where Source is defined (i.e. Source = ..) and replace this line with the following code:

Source = Json.Document( 
  Web.Contents(
    "https://www.boundplatform.ca/api/router/submission-token/", 
    [ 
      Headers = [
        Authorization = "Bearer " & Token 
      ]
    ]
  )
)

You can copy and paste this code directly into the editor. Click Done once finished.

4
Refresh Data

Click Refresh Preview to get the updated data.

Download with GET Request

You can retrieve the submission data using a standard HTTP GET request and your generated access token.

1
Add the token to the Authorization header

Use the Bearer scheme with your token.

2
Use any of the following code samples in your preferred language
curl -X GET "https://www.boundplatform.ca/api/router/submission-token/" \
    -H "Authorization: Bearer YOUR_ACCESS_TOKEN"
Powered by AriaDocs