Hello,

I have designed a data table, and am now trying to get my function to add rows within it.  No luck as of yet.

Is it as simple as this:

newRow = incident.addRow("new_row")

newRow["a"] = results.a
newRow["b"] = results.b
newRow["c"] = results.c

?

This is what i got from the few examples I could find on the subject.

I see there's an updated function for basing new rows on existing ones with only minor changes.  But documentation on this seems scarce, which leads me to believe that it should be either drop-dead simple, or else more documentation and examples are needed.

FYI, the above is not working for me, but it could of course be due to something else in my code of which I am not aware at the moment.

Just wanting to confirm that I have at least this right so far, and also hopefully get listing/confirmation on error conditions which would prevent addition of the row, such as omitting a field, misspelling, etc.

No other functions to be called here to ensure the addition of the row?

Any feedback appreciated. 

Thanks,

-Tony

------------------------------
Anthony Bufort
Integrations Engineer
DomainTools
Renton WA
14252214447
------------------------------

That should work provided you have created the datatable called "new_rows", with columns api_names of a,b,c  

As a sidenote trick, I often find it easy to use the "scripts" tester when I run into problems like this, make sure you have a test incident with the table on it, then create a new script from customization settings. 

Add your code and just "hardcode" your variables for results.a (change to "someVarForA" etc) then you can do a test run against the incident and it will show you the debug errors.  

 


------------------------------
CRAIG ROBERTS
------------------------------

Original Message:
Sent: 02-19-2019 07:47 PM
From: Anthony Bufort
Subject: Using addRow in Function Scripts

Hello,

I have designed a data table, and am now trying to get my function to add rows within it.  No luck as of yet.

Is it as simple as this:

newRow = incident.addRow("new_row")

newRow["a"] = results.a
newRow["b"] = results.b
newRow["c"] = results.c

?

This is what i got from the few examples I could find on the subject.

I see there's an updated function for basing new rows on existing ones with only minor changes.  But documentation on this seems scarce, which leads me to believe that it should be either drop-dead simple, or else more documentation and examples are needed.

FYI, the above is not working for me, but it could of course be due to something else in my code of which I am not aware at the moment.

Just wanting to confirm that I have at least this right so far, and also hopefully get listing/confirmation on error conditions which would prevent addition of the row, such as omitting a field, misspelling, etc.

No other functions to be called here to ensure the addition of the row?

Any feedback appreciated. 

Thanks,

-Tony

------------------------------
Anthony Bufort
Integrations Engineer
DomainTools
Renton WA
14252214447
------------------------------

Original Message------

That should work provided you have created the datatable called "new_rows", with columns api_names of a,b,c  

As a sidenote trick, I often find it easy to use the "scripts" tester when I run into problems like this, make sure you have a test incident with the table on it, then create a new script from customization settings. 

Add your code and just "hardcode" your variables for results.a (change to "someVarForA" etc) then you can do a test run against the incident and it will show you the debug errors.  

 


------------------------------
CRAIG ROBERTS
------------------------------