• How to retrieve clob/blob text from sagex3?

    Hello, Is there a way to retrieve a clob/blob text from sage x3 by using the REST api1? If that is not possible, which workarounds exist to still get the text? Thank you,
  • why i can't set query of VACITM facet to yes in ITMMASTER representation

    when i click on the query cell to change it to yes it just jump for initial state, but for some others columns it's ok
  • REST Web service Pagination

    Hi everyone, I'm using representations to use the REST web services in sage x3 v12, and it's working fine, but some parameters it seems not to work. I want to do a pagination when I use the $details facet, but it's not working. looking this page…
  • Insert new line in AOWSIMPORT web service

    Hello, I'm trying, on Sage X3 V11, to import a Task using the specific X3 Model with the help of AOWSIMPORT WebService. The X3 Model for Tasks defines the field separator as a new line (\010\013), but as soon as I put a newline inside the I_FILE in…
  • Trying webservice with object BOD and field BOMALT

    Hi all, when i try to create a new BOMP with Web Services it always return me this error "BOM code : 1\Record does not exist" on Field error [M:BOH0]BOMALT and i am sure that code "1" exist on my Sage X3 v9 (patch 6). this is my xml so far: <PARAM…
  • How to use text datatype (ACB) with classes and representation?

    Hello, I am trying to use a text data type in a class/representation, but I keep getting the following error message when I run my API: {"$diagnoses":[{"$severity":"error", "$message": "X3 engine error: [Microsoft][SQL Server Native Client 11.0]Invalid…
  • REST Web Service got error "X3 engine error: Inconsistant data".

    FormerMember
    FormerMember
    When I try to insert a record in a custom data table though POST request with JSON data, if I submit a wrong format, for example, leave a comma at end of the last field, I will get error { "$diagnoses": [ { "$severity": "error", "$message": "X3 engine…
  • How to avoid duplicates in a rest API call?

    I am currently getting duplicates in my rest api call and I am not sure how to fix it. What I did to create the rest api is the following: Created a dictionary view then I created a class and then I created a representation. In the dictionary…
  • Product Web service - Query a list of records

    Hello, I am having a requirement where the Product web service needs to return all products with relevant product details information if the creation date or modification date greater than a input date given by external application. Can somebody guide…