Hi ALL
I'm new to HighQ, but I'd like to use it with the API. I've had some success at logging in and reading data from HighQ using the API using POSTMAN, and I'd like to start adding new records to an existing iSheet. At this point I'm working with VERY simple elements:
A new iSheet called : apitest
it has an isheetId of : 15
It has one added column named : TestName
the columnId for the TestName column is : 135
I've tried everything I can think of to make a POST to add an entry to this table but nothing seems to work. .
I've been through the swagger documentation and it's very tough to follow. The example for the POST 'item/create' command for example is over 436 Lines LONG!!! That is not helpful!! . :oD
Can anyone provide a simple test POST Command for adding a new entry to an isheet?
Below is an example of my POST and JSON body (see below).
and I always get an error 400 response stating: "Request resource or xml is not valid"
Thanks in anticipation.
T
POST:
siteaddress/.../create
BODY:
{
"metaData": {
"siteId": "3",
"sheetId": "15"
},
"head": {
"headColumn": [
{
"columnValue": "TestName",
"sequence": "4"
}
]
},
"data": {
"item": [
{
"externalID": "",
"itemid": "string",
"column": [
{
"sequence": "string",
"rawData": {
"text": [
"Test Name Text Test"
],
"linkDisplayName": "string",
"linkDisplayURL": "string"
},
"title": "string",
"type": "string",
"mandatory": true,
"columnID": 69
}
]
}
]
},
}