How to connect CSV with URL to Adriel

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

Lastly modified on: Wed, 5th June, 2024 at 01:47 PM

Prerequisite

• An API URL to access the CSV file that you want to connect to.
• CSV File is supported by a separate connector named "CSV File."

Instructions

Step 1: Connection Setting

1. Move to Adriel's Connections page.
2. Type "CSV with URL" into the search bar.
3. Fill in the Connection Name.
   

Step 2: Data source setting and connecting CSV with URL to Adriel

1. Fill in the four required fields.
   1. Name: Fill in data source name; any identifiable name is sufficient.
      1. Optional configuration is possible. If wanted, fill in the "Alternative Channel Name." 
         1. No icon is provided as a default for this feature. However, there are channels that can use internally saved icons and display next to the channel name you just wrote down.
         2. Refer to this guide to input the correct name to display the icon. 
            https://academy.adriel.com/en/how-to-set-alternative-channel-name-for-file-db-data-source
      2. (Optional) Fill in the "File Name to Filter" and click "Submit."
   2. URL to CSV: Write the URL form of API in this field. Replace the actual date with "$date" in the URL. Refer to the example below. 
      https://rest/reportapi/performance-report?key=192938293ai&date=20230328&type=csv  
        >  https://rest/reportapi/performance-report?key=192938293ai&date=$date&type=csv
   3. Date format: How to format the date when sending a request.
      Any format that includes "yyyy, MM, and dd" is possible. Write year and day in lowercase.
      ex) yyyy.MM.dd or yyyy/MM/dd
   4. Unique Key: Column name that will be used as the key
2. Click the “Submit” button below to complete the data connection.
   
   

   It can take up to one working day for your data to arrive.