• Prerequisites
• Connecting to CData Connect Cloud with Axios

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

Prerequisites

Before you connect, you must first do the following:

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

Connecting to CData Connect Cloud 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 CData Connect Cloud 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.