1. Adriel Academy
  2. Connect
  3. Integrate - Analytics Platform

How to connect CSV with URL to Adriel

Detailed instructions to help you set up the data source for CSV with URL

First of all, you need an URL to access the CSV file. 
If yes, please move to Adriel's Connections page.
(If you want to upload a CSV file, you can try via the "CSV File" connector.)

1. Type "CSV with URL" into the search bar.

2. Enter a connection name. 

3. For data source settings, enter below four fields that are required and click the "Submit" button. 

  • Name: Enter data source name - any readable name is sufficient. 
  • URL to CSV: Input the URL form of API to this field. In the URL, replace the actual date with "$date".  
    • Replace the underlined part to date=$date and input the full URL to the field as below example.
      • Before - https://rest/reportapi/performance-report?key=192938293ai&date=20230328&type=csv
      • After - https://rest/reportapi/performance-report?key=192938293ai&date=$date&type=csv
  • Date format: How to format the date when sending a request
    • Any format that includes "yyyy, MM, and dd" is possible.
      For year and day, it should be in lowercase.
      • ex) yyyy.MM.dd or yyyy/MM/dd
  • Unique key: Column name that will be used as the key

4. You are done! Please wait, your data will arrive soon.