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


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 = '';
     //Your data to be sent in the POST request
     const data = {
     "query":"SELECT * FROM Snowflake1.PUBLIC.Accounts"
, data, {
         auth: {
             username: user,
             password: pat
     .then(response => {
         const rows =[0].rows;
         const schema =[0].schema;
         //Create an array of column names
         const columnNames = => 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;
     .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.