Continuing the discussion from Webflow API Tester:
#How to export your CMS items using the Webflow API.
The tool we will be using is the Webflow API Tester.
This tool was originally created to show off the functionality of the Webflow API and how it works, but we can use it to connect to our sites and view collection item data.
The data returned by the API is in a format called JSON. We can use other tools to convert JSON to a table format so that we can copy it into a spreadsheet.
#Step 1:
Create an access key for your site/project that you want to view/export content from.
#Step 2:
Proceed to the Webflow API Tester.
#Step 3:
Paste site access key. Click “Fetch Data”. Select and copy Site ID in result.
#Step 4:
Select “Sites > List Collections”, paste the copied Site ID. Click “Fetch Data”. Copy Collection ID from result.
#Step 5:
Select “Collections > Get All Items”, paste the copied Collection ID. Click “Fetch Data”. Copy entire result.
#Step 6:
Use a JSON to Table tool like json2table.com
Select and copy the table contents, paste into your spreadsheet.
Repeat #5 and #6 for every 100 collection items, changing the “Page Number” (offset).