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?
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.
rest api AML
Is it possible to send body with AML to rest api and get aml response? I could create a method that accepts string and parse the aml and reply but not sure how that would apply on the rights (trying to get only the items the logged in user can see, not the items that the user under which the method will be called - assuming "credentials" are not forwarded)
