How do we handle ExtraTables?

[PPetterssonSO]

I was expecting to find something like: soApi.getExtraTableAgent() or similar.
How can we create/load/update extratables?

Regards
Pär

[ejfasting]

Hello @Nawksen,

In the REST API you would use the DatabaseTableAgentto read/insert/update rows from an extraTable.

Example:

var temp = soApi.getDatabaseTableAgent();
var result = await temp.readRowAsync("y_dummy", 1); //First parameter is table name, the second is id to read. Similar to what you pass inn to the [REST API](https://docs.superoffice.com/en/api/netserver/web-services/howto/custom-objects/rest-get-custom-object-row.html?tabs=DatabaseTableAgent)

const obj = JSON.stringify(result, null, 2);
context.result.body = obj;

[PPetterssonSO]

Works perfect, but, may I please have an example on how to create a new row and populate a field as well please?

[ejfasting]

Sure:

var databaseTableAgent = soApi.getDatabaseTableAgent();

//This is the tableRow-object you need to pass inn. Note that it is (almost) identical to the [sample on docs](https://docs.superoffice.com/en/api/netserver/web-services/howto/custom-objects/rest-add-custom-object-row.html?tabs=DatabaseTableAgent). 
var newTableRow = 
{
    "tableName": "y_dummy",
    "values": {
        "x_text": "From typescript"
        } 
};

var result = await databaseTableAgent.insertRowAsync(newTableRow); 
const obj = JSON.stringify(result, null, 2);
context.result.body = obj;

You then get the id of the new row back (in my case Id = 4):

//Eivind

[PPetterssonSO]

You are now officially my favorite Norwegian!

[ejfasting]

Glad to hear it! :)

FYI I've added samples for read/insert/delete/update to the repo

Have a SUPER day!

//Eivind