Greetings All MS Access Fundi's,
I need advice as to how to go about importing webhook notifications sent from our Courier Company to an endpoint URL into our local server based MS Access Application.
Notifications containing 'Proof of Delivery' information (fields: WaybillNo, User, Base64 image file) will be provided to us by the courier backend system as and when 'Proof of Deliveries' become available and I need to grab these notifications and import the WaybillNo, User and Base64 into a table. These notifications will be sent in JSON format as Rest API's.
I need advice as to how to setup the required endpoint URL, implement an 'listener' application that will 'poll' the endpoint for new notifications and respond to the sender's backend, as well as to get the notification content into the MS Access application on our local LAN server.
JSON Rest API sample code of what we will be sent below:
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
Any forthcoming advice will be greatly appreciated. Please note that we are more than willing to compensate financially towards a solution.
Looking forward to any response and suggestions.