Morning All Access Professionals,
I have, which I believe to be quite a unique requirement, relating to the processing of Rest API's (webhooks) into a MS Access Table/Application. A solution seems very hard to find!
Some background information:
We have an MS Access Application residing on a local LAN server which is geared towards automating communication between ourselves and our courier company. The application consolidate invoicing information from our ERP System down to Customer Delivery Address level and successfully allow the sending of parcel collection requests (utilizing API calls) to our courier company's backend server. In response to each collection request, the courier's backend returns a JSON formatted Waybill No as a reference code. I can successfully process these responses and update the relevant MS Access records with these Waybill No's. So in short, the submitting and processing of these API calls to them and their responses are working fine and I have no issues with this process.
However, the courier company would also like to send us Delivery Confirmations (Proof of Deliveries) once deliveries have been confirmed; only this time by using Webhook notifications (Rest API's in JSON format). These notifications will each include the Waybill RefNo, a persons name, as well as an image (of the actual signed Waybill document) in Base64 format.
In order for the courier company to enable this functionality they request an URL (from us; to send the webhook notification to) and I need to pick up these notifications and update the relevant MS Access table containing the Waybill RefNo with the information contained in each notification we receive from them.
Here then my question(s):
- How do I setup the required endpoint URL to receive these notification and where does the URL have to point to?
- How do I receive and respond to these notifications (I'm pretty sure that there would need to be some sort of 'listening' application running on the endpoint URL to do this)?
- How can the information contained in each notification we received be processed into our local MS Access database?
ANY assistance would be greatly appreciated!! ***We are willing to pay towards implementing a solution. You are welcome to inbox me personally at johand@westcor.co.za ***
In addition, I have added the JSON code of the mentioned notification that will be sent to us via their webhooks:
========
1.40.5.403
Code:
{ "meta": { "webhookRequestReference": "0777e722-f1c4-4565-9f93-0a6e99b03a91" }, "data": { "event": "order.w2d.action.POD", "eventCode": "1.40.5.403", "description": "Proof of delivery provided by Pargo", "timestamp": "2022-05-12T11:46:01+00:00", "reference1": "PAR4035600243", "reference2": null, "extraReference1": null, "extraReference2": null, "extraReference3": null, "payload": { "receiver": { "name": "RECEIVERNAME", "signature": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAARgAAACWCAYAAAAFQ5eQAAALjElEQVR4Xu2dWYg8VxXGE9cEFVwCBlFs1weXxIAQH1zaFx9UNOKCiOAfcSMkKCJEY9B/8EFcEBVcQNEBURFRI2rexBYNQYUsQvDBbQIuiYIad9y/j9SVoumlZrrP7bp1fgWH7p6pOvee3znz9a1bt2rOPYcNAhCAQBCBc4P84hYCEIDAOQgMRQABCIQRQGDC0OIYAhBAYKgBCEAgjAACE4YWxxCAAAJDDUAAAmEEEJgwtDiGAAQQGGoAAhAII4DAhKHFMQQggMBQAxCAQBgBBCYMLY4hAAEEhhqAAATCCCAwYWhxDAEIIDDUAAQgEEYAgQlDi2MIQACBoQYgAIEwAghMGFocQwACCAw1AAEIhBFAYMLQ4hgCEEBgqAEIQCCMAAIThhbHEIAAAkMNQAACYQQQmDC0OIYABBAYagACEAgjgMCEocUxBCCAwFADEIBAGAEEJgwtjiEAAQSGGoAABMIIIDBhaHEMAQggMNQABCAQRgCBCUOLYwhAAIGhBiAAgTACCEwYWhxDAAIIDDUAAQiEEUBgwtDiGAIQQGCoAQhAIIwAAhOGFscQgAACQw1AAAJhBBCYMLQ4hgAEEBhqAAIQCCOAwIShxTEEIIDAUAMQgEAYAQQmDC2OIQABBIYagAAEwgggMGFocQwBCCAw1AAEIBBGAIEJQ4tjCEAAgaEGINAOgZm6+ofOmug1AtNEmuhkcgIWlnfKznTi8qBWeCAwrWSKfmYkMFfQb5E9rxf8h/T+Ta3AQGBayRT9zETAwvIu2dOXgv6RPj+hJRAITEvZoq9TJ7BOWG5Q4J+UHbUGAIFpLWP0d4oELCzvlj1tKTgLyzWyRatBIzCtZo5+T4HAOmG5XsG9r2VhKclBYKZQpsTQGoF1wvJ5BXK17Li1gNb1F4GZSiaJowUCM3XyM7LlydvJCQsjmBbKkT5OhcBF3VzKS5cCmqywIDBTKV3iGDuBs+rgO2T9s4XmJ2+HQucUaSgp9oPAyQhcpt0/Jruwd9j39P6tssXJXLW7NwLTbu7o+TgJPFDd+oLsOb3u/UvvfXp03Ti7HNcrBCaOLZ7zEfASfq9nOa8L/e96fZvsg/lQ3B0xAjPezPub8OJe9+6v97Y7BnS5DMv3vW9p+vF682vZ1wf0JcMuMwX5RdlTe8F+Se9fI/Pdz2k3BOZwqfelyifLPJS2mMwP15VTt0z93H3jYX/U8lt9fplscWqqEzqQAjlMMs+qWd9+3/L2G3X+oS0HsGPfZzp+edTycf3Mp0SpRy19rgjMjlV2wsM9UrlJ9qgTHjfG3TPXjkXEXxD37RJzrNcXyW4ZY6IO2afMRVKbu8Xlp7IHdw37ysJnu6IshelvPoq0dmaGtzfXrp+QPbZ3yHv03pee2VYQQGDqlcXv1JSfRPYfme+Q9Xk7WxsE/OXwEdkret31l8VL+ELYnEAEpk6B/0TNPKZr6pl6/U6dZmllRwIWljfKrpKd3/PFqGUgWARmIKgddvPNba/sjn+5Xr0Ii+0wBHxP0CNkf+41f6veL0/K+gqfH1N5hcxLA8rmlbjO4fFhut9eqwhMbM6eIvc3d034xrb+EDu2ZbybgEcgL5TNO5ttwFLmv7zP8n536mdvkKVbibtrGSEwuxLcfPxf9WsPrf8hK1ccYlvEexGVM52obCLiiXZv91qzkxcTvleWdiXuruWEwOxKcP3x/hb8effrr+rVN7+xxREwb186frHsARuauV2/e+SWbvxTv3+d7Ciuuzk8IzBxebagfKVzf61ez8Y1ldqz51U8Cbvq9POPXQ4WerUdL5GyKNn6m/dZ3i814F2CR2B2obf5WAtKWa377K7A41rL6dnL9D8g69fxn/T5U7IjGWuKDlwXCMzJE9C/EuHzfU/krlog5/N2/87bq2U/G9CUr1j4W5fL2JthmfuXZRbusv1Sb7y+yMLCNhICCMzwRMy0a/n3ncOPOv2eRbQWcnEs+3b3enqP0zjSebhRVu4Y90TtaxGWcSYXgdmel03n+NuPPvke/9Yh91xzmEXHl0q/L/NjF394cvdNH/EM9f6bsnt3UXxar2+WcXPhSNOKwGxPzH9X7OIHCfWfteICtyj48QtDN49IyvasLQf5qoa38odVdvccw5HMV6mOhzbc6H4Wl291nC3Cr5L5Xi62ERNAYDYn52/6dXk62a5p9OVRf+OWbaE3q+Zc5vp5mdvxHI5t22VV+7TYeN7HYjO1b/TLFdOHO3H5i1690pYJ3F0rssLxCMx+BcY3Mt5jh7wdd8f+QK9ezv4LmZ+74j8m38Fr8fHl2P5Ixov4vN2ney2nUb40Xvzt0KWDH+on8jsWb7+XPVo2NQE9OOSoDiAw28nOtIutjCp8RPlZeT9khLG9pe17+NTM5j805+4CWf9eGYtS//Pn9Nk35rU6V+NToLK+5Vd6/0TEZXuRjGkPBGa/2egLjz3PZW+XrVuKvt/W13u7Tb/yKOjHS7v4Z2U04BGSbwT05kdLeCvPrimfh/TXIwxvmy7L+6Fb393gzBPr35A9vNvHE9rL/w1xSF/Y58AEEJg6CZipmbnMr/2RkFv3iMMC5LmeYlN/FKUnzledSpqNV+XaSm1+Te9fUCdNtLJvAgjMvonu39/z5dKjC9uTZF7/4VOjh+y/qWoePXK6ZKm1M/rsh3CV9S2ez7pS9tFqvaKhvRNAYPaOtKrDMhry61zmU4ryOEc/4Ko/H1O1Yxsa8xxSeXiT++0HOvnGwof1jvHE9aUyrhSNJWun7AcCc0pwjRzmUYEvjfuP2qdfHhW8XuYn7PXnX2qH40vvFhY/crIvgl4WcLXMl9vZJkAAgZlAEreEcKTfe1FauYTuSV3fw1N7dOCJ2+fKfFVoeUGi17a8vxMWLkFPqCYRmAklc00oPg3xepr7yXw1yFeGaonMTG35iXJnZB61LG++89l3Q3vEgrBMsBYRmAkmdUVIFpmFzP+KtojMXd1o4vo9IrCguI257DKZP6/afJvEUWd7bB5XYyOAwIwtI3H9WSUybs2nShYfjyBs5dSpzI14Dcqq0YXvDfK6mcfJPDqxrRMUt+P7qXxFyKOV47gw8TwmAgjMmLIR35e+yHgtSnT+ff/VdbKjnnDFR0kLoyEQXWCjCZSO/J+ARcYPsx56E6eftzJ0JbJPuxadWVgYqSQvPAQmbwH4lGYu65/azPR56H1VvirlJ+/5lKqcZiEoeetpZeQIDAWxjYBFqL/152m2HcvvkxNAYJIXAOFDIJIAAhNJF98QSE4AgUleAIQPgUgCCEwkXXxDIDkBBCZ5ARA+BCIJIDCRdPENgeQEEJjkBUD4EIgkgMBE0sU3BJITQGCSFwDhQyCSAAITSRffEEhOAIFJXgCED4FIAghMJF18QyA5AQQmeQEQPgQiCSAwkXTxDYHkBBCY5AVA+BCIJIDARNLFNwSSE0BgkhcA4UMgkgACE0kX3xBITgCBSV4AhA+BSAIITCRdfEMgOQEEJnkBED4EIgkgMJF08Q2B5AQQmOQFQPgQiCSAwETSxTcEkhNoTmDm8/nNypn/GyEbBLIRuGWxWFzSUtAtCoz/TenFLUGmrxDYE4FbJTBNfbk2JzB7ShRuIACBCgQQmAqQaQICWQkgMFkzT9wQqEAAgakAmSYgkJUAApM188QNgQoEEJgKkGkCAlkJIDBZM0/cEKhAAIGpAJkmIJCVAAKTNfPEDYEKBBCYCpBpAgJZCSAwWTNP3BCoQACBqQCZJiCQlQACkzXz