Editing an item via REST API without item id. Can we specify a WHERE attribute?
Hi community, I want to edit a custom item in Innovator via REST API. Typically the command looks like this: PATCH {base url}/Part(’16AA95A80DEB4B56BD8BA9BC509EAF0C’) My 2nd software that shall do the REST call doesn´t know the target item id. I only have the serial number (item_number) of the target item in Innovator. For regular AML queries we can use the WHERE attribute to perform these kinds of edit operations. Is something similar available in the REST API? An alternative solution would be to do a regular GET request first to get the ID. Or maybe a custom Method that does the edit with a standard AML query. Any ideas? What would you recommend? Thanks! Angela
How to build an aml request using a request in a request ?
Hello Aras Community, i am would like to perform this SQL request but in using AML : Innovator _innovator = this.getInnovator(); StringBuilder sql = new StringBuilder(); sql.AppendLine("SELECT ID, ***_code, config_id, state, Major_Rev, Generation, is_current FROM innovator.[***_ROOT_***] ***1 WHERE ***1.generation =(SELECT MAX(generation) from innovator.[***_ROOT_***] ***2 where ***2.state = 'Working' AND ***2.config_id = ***1.config_id)order by modified_on"); Item ***_result = _innovator.applySQL(sql.ToString()); return ***_result; Basically i need to do a request in a request. Do you think this is possible ? thank you so much for any help.
