Browse By Tags

  • Connecting to an external REST with an XML header

    I am trying to connect to an external REST library that requires the content type to be XML and not JSON. The web service configuration seems to indicate that this should be possible since you can select XML as the the content type during the setup process…
  • Rest API Call with Patch Method

    Hi, I'm writing a interface between Sage X3 and an external platform through Rest API. The GET and POST Method work well, but I can't use the PATCH Method. I have a 400 error code from the platfom, with the message "A non-empty request body is required…
  • Parsing JSON

    Hi, Just wondering if there is any tool (function) I can use to parse JSON string using 4GL. If therse isnt any builin function avaiable then what would be the best way to parse the REST JSON data. Thanks
  • Trying to return a Using ASYRRESTCLI.EXEC_REST_WSCLB how do I get my RETVAL to bring back more than 250 Chars?

    Hi There I am trying to return a Using ASYRRESTCLI.EXEC_REST_WSCLB how do I get my RETVAL to bring back more than 250 Chars? Here is my code
  • Set Timeout for web services rest call using ASYRRESTCLI.EXEC_REST_WS

    When launching a request via REST web service with the ASYRRESTCLI.EXEC_REST_WS instruction against a third party Endpoint, I need to control a certain time in which, if the Endpoint does not respond, to exit the call and return error by TimeOut. Currently…
  • Post detail/child with REST API

    Hello, I'm struggling to POST a new register with the REST API. I tried with my SPE class, representation and Tables. Also tried with SHIPMENT, wich have edit facet. If I set it with no collections, it creates the header, but if I try to create…
  • Subprogram with rest

    Hello everyone I developed a web services(Subprogram) using SOAP, how I can do it again using the REST method, Please can you help
  • Trying to read the products of Magento from X3 using rest api integration and Node JS Error

    Hi All, We are trying to read the product of Magento from Sage X3 using integration methods such as Rest webservices, Node.Js for one of our client. The Magento API endpoints uses 'OAUTH1' type of authorization for authentication of the Rest API requests…
  • How to request for all records of a representation

    Hi, I would like to create a request with GET method using REST API to get all records of a representation. I can get a specific record using https://srve:8124/api1/x3/erp/TEST/SALESREP('XXX')?representation=SALESREP.$details where XXX is a sales…
  • SageX3 Rest API Web Services - how to get contract schema xsd?

    Hello Community, Using Rest API Web Services in Sage X3 how can I get a contract schema definition XSD? The goal here is to get a list of available resources. SDATA documentation ( http://sage.github.io/SData-2.0/pages/core/0401/ ) says it is possible…
  • Address Validation with Avalara

    Hello, We have encountered an issue when validating addresses where the FOB and ship method are automatically changed after validation is complete. Is there a way to prevent the FOB & Ship Method from being restored to default? Thank you for your…
  • Has anyone used an external requisition software?

    Has anyone used a software package that integrated with Sage 500 ERP for creating Requisitions outside of Sage and then generating Purchase Orders in Sage? What software did you use? How did that process go? Any recommendations or precautions?
  • External web services timeout error

    I'm trying to connect to an external IBAN service https://api.iban.com and I've added this to Sage under REST Web Services, however I keep getting a timeout error when trying to do a GET request. The service is available through the server directly…
  • Sage EM and REST OData

    Hello! I have a customer asking if Sage EM's implementation of REST supports OData ( https://www.odata.org/ ). I've seen some information on other Sage products but nothing specific to Sage EM. Does anyone have any information on this? Thank you,…
  • Rest Webservice

    Hi all! X3 V11 I Need to create a new endpoint from an external app, but endpoints are saved in mongo db. Can i use the rest webservices in x3 to create this new endpoint, or is there any other way of doing this from an external app? Any suggestions…
  • Access Quality Control Questions from REST API

    We have a separate Quality Control application that I would like to update the Quality Control record on a stock item automatically. I have not been able to do this with the REST api. First the the quality control detail technical sheet class is of…
  • How do you use the instanceUrl in the REST responses?

    Using the $protoype requests I can see that the representations have instanceUrl property, however I am unable to use these: "$baseUrl": "">servername:8124/.../TESTI", "$baseType": "application/json;vnd.sage=syracuse;vnd.sage.syracuse.representation…
  • Sage500 API Documentation

    I am new to Sage and we are looking for Sage500 API documentation because we need to pull data from Sage into a different receivables application. I have been looking around on the website and cannot find anything and I have made 10 calls to 10 different…
  • Is there a tool that will allow Sage 500 to retrieve a file from FTP for automated processing?

    Trying to integrate Sage 500 A/P with a third party application that drips a batch file into FTP. Sage 500 processing is already automated to process the batch, but it needs something to allow it to automatically retrieve the file from the FTP server…
  • how to download sdk

    i am trying to integrate sage 500 with my application , but i am unable to find from where i can download sage 500 sdk ....can any one help me out ? thank you
  • Programming Sage 300

    I need to start programming in sage 300. Typically programs that import etc. What software do I need and where can I get a good tutorial on this? I have no starting point.
  • Online Portal and/or Ecommerce Integration with Sage 300

    Hi, Does anyone have any recommendations for Online Portal and/or Ecommerce Integration with Sage 300? Requirements: 1. It must integrate with Sage 300. 2. Integrate with Ariba and Ariett 3. Be able to take Credit Card Payments 4. Be able…
  • Creating customer through API aka stored procedures

    I have been trying to create a customer in Sage 500 by means of sage provided stored procedures. To start with, I have my own stored procedure which creates a record in staging table, ie. stgCustomer. Thereafter, I invoke a stored procedure(api by Sage…
  • Importing customer payment for existing invoice

    We have an existing payment engine that processes credit card and checking. I have created the ability to lookup invoices with a balance, "grab" all the details and offer customer payment through other means. Now I need to bring the payment information…
  • Are there any stored procedure to create/update customer and customer contact?

    I recently started working with sage 500 api which is really a set of stored procedures. At this stage, I want to create/update a customer as well as the corresponding contact. Does anyone have any idea of what stored procedures to use for this purpose…