Bulk Read Rows

Catalyst allows you to perform bulk read jobs on a specific table present in the Data Store.

In the SDK snippet below, the Bulk Read job can read thousands of records from a specific table and generate a CSV file containing the results of the read operation, if the job is successful.The table is referred to by its unique Table ID.

Copy the SDK snippet below to perform a bulk read job on a particular table.

    

        
copy
        

            

        
    
    

         // bulk read
const bulkRead = dataStore.table('sampleTable').bulkJob('read');

// create bulk read job
 const bulkReadJob = await bulkRead.createJob({
  criteria: {
   group_operator: 'or',
   group: [
    {
     column_name: 'Department',
     comparator: 'equal',
     value: 'Marketing'
    },
    {
     column_name: 'EmpID',
     comparator: 'greater_than',
     value: '1000'
    },
    {
     column_name: 'EmpName',
     comparator: 'starts_with',
     value: 'S'
    }
   ]
  },
  page: 1,
  select_columns: ['EmpID', 'EmpName', 'Department']
 };
 {
		url: 'https://hr.zylker.com/en/EmpRecords/_callback.php',
		headers: {
			'src': 'ZCatalyst',
			'operation': 'bulkreadAPI'
		},
		params: {
			'project_name': 'EmployeeDatabase'
		}
	});

// Get bulk read status
await bulkRead.getStatus(bulkReadJob.job_id);

// Get bulk read result
await bulkRead.getResult(bulkReadJob.job_id);