CCDS and CCL Column Order
You can import data with Custom Cloud Data Sources (CCDS) or Custom Cloud Loader (CCL) scripts and retain your column order after changing column types.
CCDS API Changes
Release: 2021-05-14
You can now specify the Column Ids in the getRowset(columnIds) method.
- getRowset(columnIds)- Returns the Rowset object that rows are added to using your specified column order.
Example:
context.getRowset([ 'NAME', 'ID'])
CCL API Changes
Release: 2021-05-14
You can now specify the Column Ids in the
createTableReader
(columnIds) method.- context.createTableReader(columnIds)- The ReadRow() method returns data in the order of specified column Ids when you input an array of column Ids as parameters in the createTableReader(columnIds) method.
Example:
context.createTableReader(['NAME', 'ID']);