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

    Importing Data sent via Webhook (JSON Rest API)

    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.

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    @JohanG,
    Your post was moderated. I approved it so that it could be accessible to others.

    You may be interested in the JSON Analyse and Transform for Access at Mendip Systems

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    The link kindly provided by @orange is out of date. The updated link is JSON Analyse & Transform (isladogs.co.uk)

    NOTE: The JSON code shown above appears to be incomplete & not a valid JSON file
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  4. #4
    JohanG is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2022
    Posts
    14
    Thank you very much for the provided link. I will reach out to Colin from Mendip Data Systems with additional questions. Your assistance truly appreciated.

  5. #5
    JohanG is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2022
    Posts
    14
    Thank you very much for the provided link.  I will reach out to Colin from Mendip Data Systems with additional questions.  Your assistance truly appreciated.

  6. #6
    orange's Avatar
    orange is online now Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    @JohanG You are welcome.

    @Colin -sorry for the link issue. I just googled JSON Transform Mendip and copied the link.

  7. #7
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    @orange
    No problem. The links from my old site mostly still work but not all the content is up to date
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  8. #8
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    @JohanG
    We both seem to be duplicating ...
    You with 2 threads & 5 emails!
    I've replied to your emails- the first reply was incomplete so I sent another response afterwards
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

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

Similar Threads

  1. Replies: 6
    Last Post: 05-18-2022, 09:10 AM
  2. Importing/Reading JSON to Populate Fields
    By wrayman in forum Import/Export Data
    Replies: 22
    Last Post: 09-17-2018, 10:28 AM
  3. Replies: 15
    Last Post: 04-26-2018, 01:54 PM
  4. System DSN (MS Access) to REST API / JSON
    By Hitesh in forum Queries
    Replies: 1
    Last Post: 03-15-2016, 11:37 AM

Tags for this Thread

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