Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Installing "SData Adapter.exe"
Getting the following error during the install. After the error the install stops.
0x80131509 - The specified path already exists
Sage 100 Premium 2021
Rich Garrett
DSG, Inc.
So I've got SData installed and working. I can ping AR_Customer to get a list of customers. However, attempting to post to this endpoint with the following body fails:
Of note, I've slimmed down the payload to only what is known to be the simplest required…
Hi Everyone,
We are working on an ecomerce intergration using Sdata. A plain order works with the lines, qty and price coming over.
We are stuck when we try to sent a SO that has Parent Items that need work tickets created and assigning the child…
We are looking at a Third-Party software called Master Control for our QA/QC documentation processing. With that, we want to be able to extract data out of Sage 100c Advanced v2019.2 (upgrading to v2021 shortly) from Scanco's Manufacturing module, as…
Hello everyone!
I'm attempting to update records in `PO_ReceiptHeader` and `PO_ReceitDetail` through SAGE 100 SData (via a custom built web app), however I keep running into this error :
```<?xml version="1.0" encoding="utf-8"?>
<sdata:diagnoses…
Hopefully someone here can assist as Sage Tech Support could not answer the question.
Is the SData connector compatible with Sage 100c Premium (SQL) on Windows 2016 Server?
If yes, what version of the adapter? (Extra love for a link to it!)
…
Hello!
We just upgraded from Sage 100 2014 Advanced to Sage 100 2018 Premium.
Our website for years used e-Business web services / SData integration.
All worked fine.
And after upgrade all is good, except this small issue - custom rules with shipping…
Hello!
I am trying to create an order completely with SData and Paya.
I have no problems with it when I am trying to create an order with PaymentType = Check.
Here is the XML for such example:
<entry xmlns:atom=" ">http://www.w3.org/2005/Atom…
We've built a connector between WooCommerce and Sage 100 Standard using SData and have found that SData has some quirks that have proven to be a real pain to work around. It's also not very well documented (at least the version of SData used in Sage 100…
I'm attempting to post a Transaction using sData to the URL of our Sage 100 server and I keep getting the error: " is not on file.Š". This happens only when I have a valid AccountKey in the transaction details section. If I remove the account key I get…
I have a need to delete a Sales Order Invoice using SData and I can't seem to figure it out. When I run an HTTPS DELETE request to https://<sdata-connector-server>/sdata/masapp/mascontract/<company-name>/SO_InvoiceHeaderSPECIAL('0026094') I get the following…
We are currently using the SData Native Adapter with Sage 100 2017 to connect our store application with Sage. I'm trying to decide if it would behoove us to upgrade to Sage 100 2018 and the associated SData adapter. I'm wondering if the new adapter gives…
How do I get the SData GET to return only the XML with the requested data items? It is currently returning a ton of unwanted HTML that is a waste to transmit on every GET. I have tried different Content-Type options, but nothing I tried has worked:
…
Upgraded from v2014 to v2016. When trying to transfer data from third party (Service Pro) to Sage 100 through SDATA, client is receive the following error:
{ "d": null, "Message": "PVX data deserialization failed.", "Errors": { "Validation": [], …
The only useful documentation/tutorials I can find for SData is a really old youtube series on SData Consumers and the SData 2.0 github page. Which is the recommended implementation for using SData? If you could provide an example of the second option…
I'm trying to test out my connection to the SData portion of my installation of Sage 100 ERP. When I test it using the C# Client helper way of adding an SData Reference in my VS project using a url to the schema file (ex: http://[server name]/sdata/MasApp…
Hi There...
I'm working on an ecommerce integration using sData ( and PHP ) and I'm having trouble trying to create a sales order. I'm getting a message " This Order has no lines and has zero total amounts " back from the server. I know the issue is…
I have an integration built that works really well. The problem I run into is if the order has more than 40 lines on it, I get an "Internal Server Error".
Is anyone using it in a similar manner and have you run into this? Is there a workaround or…
Hi There -
I don't know if this group is still active, I'm having trouble trying to query resources by date. For instance, using this query to get sales orders:
mydomain.com/.../*** /SO_SalesOrderHeader
The query parameters I've tried:
…
We want to create an integration between Sage 100 and a SaaS product. The SaaS product puts constraints on the number of external operations per day. (By "external operations", I mean sending data to or receiving data from software or a service other…
Hello everyone!
2 years ago my company built a very powerful implementation of e-commerce store that integrated with Sage 100 ERP via both Sage e-Business Web Services and SData.
As I said after that 2 years gone. Now I am interested are those technologies…
I'm implementing an update operation for our integration and when I attempt a PUT operation I get the following error:
This entry already exists in batch SERVO.
Here's the raw request:
PUT ~/sdata/masapp/mascontract/abc/SO_InvoiceHeader('0100117…
When attempting to use SDATA to POST an AR_Customer, I'm receiving an error:
<sdata:diagnosis> <sdata:severity>error</sdata:severity> <sdata:sdataCode>ApplicationDiagnosis</sdata:sdataCode> <sdata:applicationCode xsi:nil="true" /> <sdata:message>Exception…
I am trying to get a test environment of sdata setup. I have everything installed and when I open IE and enter this url
https://machinename/sdata/masapp/mascontract/abc/ar_Customer
I get the following:
<? xml version="1.0" encoding="utf-8" ?>
…