We have an integration I am trying to get live and troubleshooting has been a pain. It works fine one week, the next week it doesn’t, etc… You know how external APIs go if you have an integration. For those of you that wrote your own API calls, are you logging those payloads and responses from the…

This is an agnostic log table as well. I have every 3PL logging to this table and can be filtered on the Action column which shows Library~Function. You can see the exact day I started working on a different integration, lol. [image]

… :no_mouth: that’s perfect.

And how did you know it was a shipping integration I was trying to log! :rofl: :thinking:

Okay word so are you just writing updates to UD table at each try catch in the integration? Or whatever error handling/logic points that make sense?

Yup. For example: if( vSku.Trim().Equals("") ) { string whse = ( from w in Db.Warehse where w.Company == Session.CompanyID && w.WarehouseCode == whseCode …

Thank you, okay. I like the function call too. Last I checked though if I want to do it on a form I have to make a rest call since I don’t have a business object that I can use.

Okay cool, thanks a ton for an example of how you are successfully doing it. I just didn’t know if I should log in database, log on client, etc.

[image] utaylor: I just didn’t know if I should log in database, log on client, etc. I chose the database so that I can put the onus back on the users if it’s something they can act upon. Like–errors of the integration is something I will have to deal with, but if it’s something like a line s…

Hahaha yes those look like my recent attempts too :rofl: But it’s funny cause the json response object was different just 3 days ago and now the field I am converting to a string no longer exists… We are using a dev api so I guess it is what it is, probably changes somewhat frequently.

[image] hmwillett: You can see the exact day I started working on a different integration That logging table is Fire! :fire: [So Excited Reaction GIF by Originals]

For all you wild ones supporting an integration via API... what's a good standard for logging?

Epicor ERP 10

hmwillett (Hannah Willett) March 1, 2023, 9:53pm 2

Direct DB Update, Add Row, Epicor Function - Cannot Add, am I missing something?

Topic		Replies	Views
Function error logged Epicor ERP 10 functions	14	3738	March 25, 2022
Write to SQL table from within BPM/Directive Epicor ERP 10 sql , bpm	23	6784	May 9, 2023
Innovation Epicor ERP 10 e10	55	11214	August 25, 2021
Create and Log to a File (in customization) Epicor ERP 10 customization	16	6784	June 17, 2020
UI Processes Epicor ERP 10	31	3378	June 28, 2018

For all you wild ones supporting an integration via API... what's a good standard for logging?

Related topics