🔍 What You're Doing
In this step, you will use the Nexadata Connector Copilot to connect to the Exchange Rate API using its OpenAPI specification and build a live dataset of foreign exchange rates. The Exchange Rate API is open access, so no credentials or API key are required. Connector Copilot reads the spec, analyzes the available endpoints, and maps the response fields into a structured dataset ready for use in a Pipeline.
✅ Summary of Steps
Select Datasets from the Setup menu.
Click AI Copilot in the top right corner of the Datasets page.
Select API Specification URL as your spec source.
Paste the following URL into the OpenAPI Specification URL field:
https://assets.nexadata.com/oas/open-er-api-oas.yaml
Click Validate OpenAPI Specification, then click Start Building Connection.
Enter a name for the connection, then click Start Building Dataset.
Enter the following prompt in the description field and click Submit:
Fetch USD exchange rates across other exchange rates
Select the /latest/{baseCurrency} endpoint from the suggested list.
Enter USD in the Base Currency field and click Fetch Data.
Review the data preview, confirm columns, and click Submit to create your dataset.
