Update ICSW fields from API

I'm wanting to update just the replcost and stndcost fields for an ICSW record. What API should I use? I've been experimenting with the PUT /sxeapi/api/ic/icsw but haven't had luck just using those fields...but I'm also probably not using the correct criteria.

Find more posts tagged with

ION API Gateway

Accepted answers

All comments

Richard France

What I do in these cases is go into CSD get to the entry that you want to change, open the dev tools in the browser, go to Network tools.

Carry out the change and look for the request that was sent and the payload

Probably you need the RowID or similar

Daniel Turner

Thanks for the suggestion. Using PUT seems to be what is used when you update a record in ICSW, but it looks like for it to work correctly, the majority of the fields have to be populated. I'm able to run it correctly with limited fields like this, but the only problem is any field left out just zeros out on the record. So I guess I'd have to grab all of the data first and then populate each field, unless there's some other API out there that can just update the price.

{
"icspes": null,
"cono": 5555,
"whse": "12",
"prod": "KIM 41600J",
"replcost": 1000000,
"rowID": "-8872717970367840256",
"arptype": "V"
}

Brandon Watson

The PUT requires all fields, as you have found. You would want to run the getbyrowid, update your fields and then run the PUT.

You could also use FieldUpdate to do what you are trying to do. Below is an example of tha API call. Ensure to update AuthID and AppKey from SASAPI entry.

{

"AuthID": "<AuthID>",

"AuthAppKey": "<GUID>",

"debug": false,

"dlcheckskip": true,

"mode": "update",

"upsert": false,

"process": [

{

"table": "icsw",

"mode": "update",

"upsert": true,

"constraint": {

"cono": 1000,

"prod": "1-008",

"whse": "main"

"update": {

"cono": 1000,

"replcost": "5.25",

"stndcost": "6.05"

}

]

}

Daniel Turner

Thanks. The FieldUpdate looks promising. Is there any documentation on the SASAPI setup?

StefanTaganyi

This is awesome as I've been wanting to test the FieldUpdate api for a while now and it works like a charm, thanks!

Daniel Turner

Sorry, probably a terrible question...it is possible to use the FieldUpdate api within a User Hook in Cloudsuite? Do you need a bearer token to execute it?

Copyright © 2025 Infor. All rights reserved.