No, there is no api. We are fetching the data directly from the MSSQL database. But fortunately the developer of our ERP provided very detailed informations about the database and the structure of its tables. So at least i knew what table stored what information. I then “just” had to find out how to fetch the needed information from which tables and to create the sql commands for it.
To make it more complicated, the app does not just fetch shipping addresses for invoices, but also for orders,return shipments and return shipments with credit memo. They are all stored somewhere else. That´s one reason why i wrote “blood,sweat and tears”. > Am 04.10.2018 um 00:45 schrieb Bob Sneidar via use-livecode > <use-livecode@lists.runrev.com>: > > I'd be curious how you did the back end integration with your ERP sysetm. Do > they provide an API? > > Bob S > > >> On Oct 3, 2018, at 15:33 , Matthias Rebbe via use-livecode >> <use-livecode@lists.runrev.com> wrote: >> >> These are the main features: >> By entering the invoice number the software fetches the corresponding >> shipping address and some other additional information like cash on delivery >> amount (if applicable) from the database of our ERP software and creates a >> shipping label, which then is printed onto a thermal printer. > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
