Axios

This page outlines the steps to connect Axios to your Connect AI account using the REST API.

Prerequisites

Before you connect, you must first do the following:

• Connect a data source to your Connect AI account. See Sources for more information.
• Generate a Personal Access Token (PAT) on the Settings page. Copy this down, as it acts as your password during authentication.

Connect to Connect AI with Axios

1. Create a project directory, for example, connect_cloud.

2. Open the terminal in the project directory and initialize a node project as follows:

   npm init -y
   
3. Install the Axios dependency in the project with the following command:

   npm install axios
   
4. In your project directory, create a file called server.js that contains the following code. Provide your Connect AI username and pat (the PAT you created in the prerequisites). You must also provide a query for your data, such as SELECT * FROM Snowflake1.PUBLIC.Accounts.

   const axios = require('axios')
    const user = 'username'
    const pat = '***********************************';
    //Your API endpoint
    const url = 'https://cloud.cdata.com/api/query';
    //Your data to be sent in the POST request
    const data = {
    "query":"SELECT * FROM Snowflake1.PUBLIC.Accounts"
    };
    axios.post(url, data, {
        auth: {
            username: user,
            password: pat
        }
    })
    .then(response => {
        const rows = response.data.results[0].rows;
        const schema = response.data.results[0].schema;
        //Create an array of column names
        const columnNames = schema.map(col => col.columnName);
        //Loop through each row and log the column name with its value
        rows.forEach(row => {
            const rowObject = {};
            row.forEach((value, index) => {
                const columnName = columnNames[index];
                rowObject[columnName] = value;
            });
            console.log(rowObject);
        })
    })
    .catch(error => {
        console.error('Error:', error);
    });
   
5. In the terminal, execute the following command to run the server:

   node server.js
   

   The query results appear.