Is there an "in" operator in the Aras REST API?
Hi community, Is there a way to optimize the following REST request that gets a number of specific items? https: // arasmagiccastle.com/test/server/odata/MagicItemType ?$ filter=serial_number eq '9879' or serial_number eq '678' or serial_number eq '643' or serial_number eq '123' or serial_number eq '234'........ Problems: 1. The number of requested items isn´t fixed, so the query can get super long 2. I don´t like it (solid argument, don´t question it! [emoticon:33306c418930400bac28808410f8ac8b]) What I would love to have: https://beautifulplm.com/test/server/odata/MagicItemType?$filter=serial_number in ('9879','678','643','123','234'). Good alternative: Another option would be to use a POST operation with @aras.action=get. This would allow us to use the filter condition inside the body. But Innovator doesn´t seem to support this variant yet. Browsers support URLs with a few thousand characters. The long query isn´t a problem right now. But I wonder if there is a more elegant solution to write requests like this? Thanks for any hint! @Aras: If you need more ideas for REST...Here you go! :)
Recursive API call to explode BOM
The internal reporting tool in Aras doesn't work for us therefore we have to use external tools. I need to explode the BOM downwards for parts. Use this data in PowerBi to create reports. I have figured how get the BOM structure but it only gives level 1. How do I drill down? This is my call to get level 1 BOM url/Part('9A75B30B66A5465BA372C30384133345') BOM($select=quantity,nmg_material_record;$expand=related_id($select=item_number,unit,major_rev))
Can <servername> in an ARAS URL include a path parameter?
link As per the above document, a valid ARAS server URL is of the pattern "https://<servername>/<web alias>/oauthserver/connect/authorize" In the above pattern, can a valid ARAS server include a path parameter within the <servername> part, before <web_alias>? for example, Is it valid to have "/aras" in the below URLs?: Access Token URL: sample.company.com/aras/<web alias>/oauthserver/connect/token Part Request URL: sample.company.com/aras/<web alias>/server/odata/Part
REST API does not return properties with Item datatype
Hi, I am using Release 15 and trying to GET all Properties of an Item using REST API with this request: http://server/innovatorserver/server/odata/par('D193004BBD7D4EF390925A859A4E371D') It does return all properties except the ones which are datatype = Item. I am able to get the missing items properties one-by-one with such requests: http://server/innovatorserver/server/odata/par('D193004BBD7D4EF390925A859A4E371D')/lead_est I tried with other ItemTypes as well and find same issue. Is this normal for OData or I am missing something in the API request? Or may be newer version has this issue fixed already? Of course AML requests do return all properties though. RegardsREST API, `Value cannot be null.\r\nParameter name: criteria` trying to get a Workflow
Hello everyone. I'm using Aras 12SP09 and I'm working with the REST API. I have an AML call that I would like to transform to a REST call, it is: <Item type='Workflow' action='get' select='related_id(*)'> <source_id>UUID</source_id> <related_id condition='is not null'/> </Item> I turned it into the following REST call: .../server/odata/Workflow?$filter=source_id eq 'UUID' but then I have an error " Value cannot be null.\r\nParameter name: criteria ". What I don't understand is, the same syntax is working perfectly fine when trying to get a Property for example: .../server/odata/Property?$filter=source_id eq 'UUID' . Is there something different for workflows? What am I doing wrong?
Upload file Rest API using Logic App
I am currently developing a sample project in Azure Logic Apps using the Aras Restful APIs. However while trying to Execute the vault.UploadFile API I am facing the 500 error message: The Rest API Call Details are as follows : { "uri": ".../vault.UploadFile?fileId=EB166A9FF4EE47C8A0DA55252CA140CA", "method": "POST", "headers": { "Authorization": "*sanitized*", "Content-Disposition": "attachment;filename*=utf-8''Hello.txt", "Content-Length": "5", "Content-Range": "bytes 0-4/5", "Content-Type": "application/octet-stream", "transactionid": "0c2c787fce70226029d752c0ba372607" }, "body": "Hello" } For now I am trying to upload a simple text file as seen above. I have verified the url as well as run the same in Postman , ARC and fiddler - and I am able to get it working in all the cases except for via Logic Apps . Please let me know if anyone knows what I am missing here . Thanks
How to return JSON from a odata method
Hi, I created a a serveur method named COCO_MONITORING returning a JSON like this var innovator = this.getInnovator(); var output= new Newtonsoft.Json.Linq.JObject(); .... return innovator.newResult(output.ToString(Newtonsoft.Json.Formatting.None)); I'm able to call it in odata like this: https://serveur/1Z62innovator/server/odata/method.COCO_MONITORING My problem is that the output of the web service is a text/plain containing the json as a text. I would like to have directly the json (application/json). How can I do that ?
Aras Rest api wrong filter behavior
I have a request: .../server/odata/Part?$filter=(id eq '...' or id eq '...') and generation gt 0&$expand=created_by_id. I'm trying to get more then one Part. One of them is an old version of another Part (thats why i'm using 'generation gt 0' filter). But also i need to expand some internal entity. So such request doesn't work. It will return only items with the latest version (i think 'generation' filter doesn't override default verion filter in this case). If i remove 'expand' from here, it will work properly. But i need to have 'expand' and such filter in One request here. I'm using Aras version 12 SP9. Summary: 'generation' filter doesn't work in case of combining it with another filter and 'expand' option.OAuth - How to use Grant Type "Authorization Code" for token generation
Hi everyone, I recently read this excellent blog post about token authentication using the REST API for Innovator, and in it Christopher Gillis says that ' urrently, I believe "password" is the only authentication type allows [sic]. Aras as a whole is moving towards more types of authentication in 12.0, so this is likely to change in the upcoming releases.' With 12.0 released, I see that OAuthServer\OAuth.config now defines two allowedGrantTypes for the clientRegistry with ID "IOMApp": 'password' - the one that I have been using in my code when generating OAuth tokens for Innovator so far - but also 'authorization_code'. Hence, I was wondering if anyone knows a practical way yet to generate the access token with that grant type, instead of using "password"? Thanks a lot in advance for any info on this subject. Cheers, C
