Extract list and contents of last 50 consignments from Lightspeed X (formerly Vendhq) into Excel using API

Job ID: 35642196

Budget: $10 – $60 CAD

Using Excel VBA I would like to connect to Lightspeed X and grap the list of past 50 consigments and their contents showing all necessary columns

Please spend time reading the guide here:
https://docs.vendhq.com/reference/getconsignments

The expected results is shown in the excel sheet attached.

Please do not rush to vote, spend time to understand the scope and rate limitation, pagination .. etc

I am not an expert in API so please take that in communication when communicating with me.
Related categories: eCommerce Excel VBA Point of Sale REST API