Hi everyone,
I was experimenting with remote tables to understand how they work. I successfully fetched records from an open-source API, and they are visible in the list view. However, when I open a record, it always displays the first record fetched, even though the list shows all records pulled via the API. Initially, I thought this might be due to a missing sys_id, so I added a sys_id to each record. Now, all records have a unique sys_id, but when I try to open a record, I get a "record not found" message. Any suggestions on what might be going wrong?
try {
var r = new sn_ws.RESTMessageV2('Visitor stat', 'Default GET');
r.setStringParameterNoEscape('lang', 'en');
r.setStringParameterNoEscape('full_series', '1');
var response = r.execute();
var responseBody = response.getBody();
var httpStatus = response.getStatusCode();
responseBodyJSON = JSON.parse(responseBody);
// var allData = [];
if (httpStatus == 200) {
for (var i = 0; i < responseBodyJSON.dataSet.length; i++) {
var rawObj = {
'sys_id': gs.generateGUID(),
'u_period': responseBodyJSON.dataSet[i].period,
'u_regiondesc': responseBodyJSON.dataSet[i].REGIONDesc,
'u_region': responseBodyJSON.dataSet[i].REGION
};
v_table.addRow(rawObj);
}
}
} catch (ex) {
var message = ex.message;
}
