Results 1 to 7 of 7
  1. #1
    JohanG is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2022
    Posts
    14

    Processing JSON Rest API Data into MS Access Table

    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

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I've reached out to someone who might be able to help you.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    This is a duplicate post for the same issue?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    JohanG is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2022
    Posts
    14
    Quote Originally Posted by Micron View Post
    This is a duplicate post for the same issue?
    Yes Micron, I was not sure if my initial post was received, so I submitted a 2nd post. Apologies!

  5. #5
    JohanG is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2022
    Posts
    14
    Thank you! Appreciated...

  6. #6
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Marking one as solved would help avoid confusion.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  7. #7
    JohanG is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2022
    Posts
    14
    Done, closed this thread...will pursue the other thread.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 12-06-2021, 02:50 PM
  2. Replies: 1
    Last Post: 10-04-2019, 05:42 AM
  3. Replies: 15
    Last Post: 04-26-2018, 01:54 PM
  4. Replies: 8
    Last Post: 01-09-2018, 04:36 AM
  5. System DSN (MS Access) to REST API / JSON
    By Hitesh in forum Queries
    Replies: 1
    Last Post: 03-15-2016, 11:37 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums