Genesys Cloud - Developer Community!

I have posted this 20 days ago but unfortunately no response and reposting now. Could you please throw some light on this topic? 

I am unable to get the all the columns from a Datatable when I set the showbrief flag to false. I can only get the key value from the table with the following fields:

id:ERS, primaryId:fb860502-9814-41d6-b5a7-e1fa112ddf24, secondaryId:7bcb11cf-59b1-416f-aa50-ed541bcb611d, timestamp:2025-04-07T23:39:42.504Z.

But it only returns the key column value:

{

"key": "ERS"

}.

Please find the code below:

async function getCurrentAssignment(tableName) {

const architectApi = new platformClient.ArchitectApi();

const tableId = await getTableIdByName(tableName);

if (!tableId) return null;

try {

const row = await architectApi.getFlowsDatatableRow(tableId, 'ERS', { showbrief: false });

console.log('Loaded row:', row);

console.log(`getFlowsDatatableRow success! data: ${JSON.stringify(row, null, 2)}`);

//console.log('Row.values:', row?.values);

return row;//?.values || null; // safely return null if values is missing

} catch (err) {

console.warn('No assignment row found:', err);

return null;

}

}

Hello,

I have created an "ERS_Agent_Assignment" table with (key, primaryId, secondaryId, timestamp) fields and tried the functions you have posted above (connecting to my Genesys Cloud org/environment.

And it is working fine for me.

Loaded row: {

  secondaryId: '7bcb11cf-59b1-416f-aa50-ed541bcb611d',

  primaryId: 'fb860502-9814-41d6-b5a7-e1fa112ddf24',

  key: 'ERS',

  timestamp: '2025-04-07T23:39:42.504Z'

}

Not knowing all details of your code (what you haven't posted above):

Are you using a proxy (or gateway) or connecting your apiClient directly to the Genesys Cloud org?

Are you calling the getTableIdByName function somewhere else (before) in your code, for a different table name?

What version of the Javascript/Node Platform API Client SDK are you using?

Can you try to run the query from API Explorer to see if you get the same result - GET /api/v2/flows/datatables/{datatableId}/rows/{rowId} ?

If you have Genesys Cloud CLI or Postman - can you try to run the query with the same OAuth Client Credentials than the one you are using in your code?

Regards,

I have posted this 20 days ago but unfortunately no response and reposting now. Could you please throw some light on this topic? 

I am unable to get the all the columns from a Datatable when I set the showbrief flag to false. I can only get the key value from the table with the following fields:

id:ERS, primaryId:fb860502-9814-41d6-b5a7-e1fa112ddf24, secondaryId:7bcb11cf-59b1-416f-aa50-ed541bcb611d, timestamp:2025-04-07T23:39:42.504Z.

But it only returns the key column value:

{

"key": "ERS"

}.

Please find the code below:

async function getCurrentAssignment(tableName) {

const architectApi = new platformClient.ArchitectApi();

const tableId = await getTableIdByName(tableName);

if (!tableId) return null;

try {

const row = await architectApi.getFlowsDatatableRow(tableId, 'ERS', { showbrief: false });

console.log('Loaded row:', row);

console.log(`getFlowsDatatableRow success! data: ${JSON.stringify(row, null, 2)}`);

//console.log('Row.values:', row?.values);

return row;//?.values || null; // safely return null if values is missing

} catch (err) {

console.warn('No assignment row found:', err);

return null;

}

}

Hi Jerome,

I am not using a proxy and I am connecting directly to the org through an implicit grant.

Hello,

I have created an "ERS_Agent_Assignment" table with (key, primaryId, secondaryId, timestamp) fields and tried the functions you have posted above (connecting to my Genesys Cloud org/environment.

And it is working fine for me.

Loaded row: {

  secondaryId: '7bcb11cf-59b1-416f-aa50-ed541bcb611d',

  primaryId: 'fb860502-9814-41d6-b5a7-e1fa112ddf24',

  key: 'ERS',

  timestamp: '2025-04-07T23:39:42.504Z'

}

Not knowing all details of your code (what you haven't posted above):

Are you using a proxy (or gateway) or connecting your apiClient directly to the Genesys Cloud org?

Are you calling the getTableIdByName function somewhere else (before) in your code, for a different table name?

What version of the Javascript/Node Platform API Client SDK are you using?

Can you try to run the query from API Explorer to see if you get the same result - GET /api/v2/flows/datatables/{datatableId}/rows/{rowId} ?

If you have Genesys Cloud CLI or Postman - can you try to run the query with the same OAuth Client Credentials than the one you are using in your code?

Regards,

I have posted this 20 days ago but unfortunately no response and reposting now. Could you please throw some light on this topic? 

I am unable to get the all the columns from a Datatable when I set the showbrief flag to false. I can only get the key value from the table with the following fields:

id:ERS, primaryId:fb860502-9814-41d6-b5a7-e1fa112ddf24, secondaryId:7bcb11cf-59b1-416f-aa50-ed541bcb611d, timestamp:2025-04-07T23:39:42.504Z.

But it only returns the key column value:

{

"key": "ERS"

}.

Please find the code below:

async function getCurrentAssignment(tableName) {

const architectApi = new platformClient.ArchitectApi();

const tableId = await getTableIdByName(tableName);

if (!tableId) return null;

try {

const row = await architectApi.getFlowsDatatableRow(tableId, 'ERS', { showbrief: false });

console.log('Loaded row:', row);

console.log(`getFlowsDatatableRow success! data: ${JSON.stringify(row, null, 2)}`);

//console.log('Row.values:', row?.values);

return row;//?.values || null; // safely return null if values is missing

} catch (err) {

console.warn('No assignment row found:', err);

return null;

}

}

Hello,

The problem is coming from your Javascript SDK version. Version 27 is too old. The current/latest version is 220.0.0

Please update your Javascript SDK version and check if it is resolved (it should - I can reproduce your issue with version 27).

Regards,

Hi Jerome,

I am not using a proxy and I am connecting directly to the org through an implicit grant.

Hello,

I have created an "ERS_Agent_Assignment" table with (key, primaryId, secondaryId, timestamp) fields and tried the functions you have posted above (connecting to my Genesys Cloud org/environment.

And it is working fine for me.

Loaded row: {

  secondaryId: '7bcb11cf-59b1-416f-aa50-ed541bcb611d',

  primaryId: 'fb860502-9814-41d6-b5a7-e1fa112ddf24',

  key: 'ERS',

  timestamp: '2025-04-07T23:39:42.504Z'

}

Not knowing all details of your code (what you haven't posted above):

Are you using a proxy (or gateway) or connecting your apiClient directly to the Genesys Cloud org?

Are you calling the getTableIdByName function somewhere else (before) in your code, for a different table name?

What version of the Javascript/Node Platform API Client SDK are you using?

Can you try to run the query from API Explorer to see if you get the same result - GET /api/v2/flows/datatables/{datatableId}/rows/{rowId} ?

If you have Genesys Cloud CLI or Postman - can you try to run the query with the same OAuth Client Credentials than the one you are using in your code?

Regards,

I have posted this 20 days ago but unfortunately no response and reposting now. Could you please throw some light on this topic? 

I am unable to get the all the columns from a Datatable when I set the showbrief flag to false. I can only get the key value from the table with the following fields:

id:ERS, primaryId:fb860502-9814-41d6-b5a7-e1fa112ddf24, secondaryId:7bcb11cf-59b1-416f-aa50-ed541bcb611d, timestamp:2025-04-07T23:39:42.504Z.

But it only returns the key column value:

{

"key": "ERS"

}.

Please find the code below:

async function getCurrentAssignment(tableName) {

const architectApi = new platformClient.ArchitectApi();

const tableId = await getTableIdByName(tableName);

if (!tableId) return null;

try {

const row = await architectApi.getFlowsDatatableRow(tableId, 'ERS', { showbrief: false });

console.log('Loaded row:', row);

console.log(`getFlowsDatatableRow success! data: ${JSON.stringify(row, null, 2)}`);

//console.log('Row.values:', row?.values);

return row;//?.values || null; // safely return null if values is missing

} catch (err) {

console.warn('No assignment row found:', err);

return null;

}

}