Sorting API data from Airtable

33 Views Asked by At

I'm trying to order the API responses from Airtable based on their OrderNummer instead of ID, since they are chronological and the ID is alphabetical.

This is the response I get:

{
 "records": [
  {
   "id": "rec1IwAO4BzxvPmfl",
   "createdTime": "2023-11-15T17:06:19.000Z",
   "fields": {
    "TrackingURL": "https://tms.futuresupplychains.com/GUI/Tracking_New/Website/DocketTrack.aspx?st_Docnolist=GHSFGURJBK",
    "OrderNummer": "#1011",
    "Status": "fulfilled",
    "KlantNaam": "Harry van 't Kamp",
    "Bestemming": "'s-Hertogenbosch",
    "Bedrag": 14388,
    "TrackingNummer": "GHSFGURJBK",
    "DatumVanAankoop": "2023-11-15T17:05:52.000Z",
    "KlantMail": "[email protected]",
    "Update": "2023-11-15T17:06:09.000Z",
    "Adres": "Sweelinckplein 1 5216 EG, 's-Hertogenbosch, Netherlands"
   }
  },
  {
   "id": "recHm3hyY1rGDib03",
   "createdTime": "2023-11-23T11:11:35.000Z",
   "fields": {
    "TrackingURL": "https://tms.futuresupplychains.com/GUI/Tracking_New/Website/DocketTrack.aspx?st_Docnolist=FKUGLUGLIJ",
    "OrderNummer": "#1025",
    "Status": "fulfilled",
    "KlantNaam": "Harry van 't Kamp",
    "Bestemming": "'s-Hertogenbosch",
    "Bedrag": 300,
    "TrackingNummer": "FKUGLUGLIJ",
    "DatumVanAankoop": "2023-11-23T12:11:32+01:00",
    "KlantMail": "[email protected]",
    "Update": "2023-11-23T12:11:47+01:00",
    "Adres": "Sweelinckplein 1, 5216 EG, 's-Hertogenbosch, Netherlands"
   }
  },

I tried using a ?sort_by=ordernummer&order=asc or similar functions, but they gave the same output as given above. Other ways to make it work in chronological order are good as well, such as ordering by DatumVanAankoop or createdTime for instance.

0

There are 0 best solutions below