1. Mario Francisco Celleri
  2. PowerBuilder
  3. Saturday, 9 September 2023 19:13 PM UTC

Hi, guys.

I have no idea what type of JSON are the replys from AirTable Web API, are?.

I tried distinct ways to parse the JSON; but don't lucky.

Can you help me to solve this, please.

 

I attached a sample of one of the JSON reply.

 

{"records":[{"id":"recMZdlpJHeKpXBjd","createdTime":"2023-07-10T13:11:55.000Z","fields":{"INSUMOS":"**INSUMOS**\n[ ] FUNDAS\n[ ] TARJETAS\n[ ] INSTRUCCIONES\n[ ] PLASTIFLECHAS\n[ ] ADHESIVOS\n[ ] MINI HARTAG\n[ ] HILOS\n[ ] PRECIOS\n[ ] REATAS\n[ ] CIERRES\n[ ] ELASTICOS\n[ ] HILOS\n\n**CONFECCION**\n[ ] VIVOS\n[ ] DELANTEROS\n","PROYECTO":["recA6L2VX5jNILQ9k"],"TALLAS_PRODUCCION":["recnCoYHVrMJrDKuD","recgLb1fgNfigWZAA","recKkbiU41k0HACyy","recDXec5ngMhHUkv5","recbcdUkHFSyYcVrF"],"ETAPA_PRODUCCION":"03 - LOGISTICA","CODIGO":"0018024","DESCRIPCION":"CAMISETA CR","FECHA_ENTREGA":"2023-07-31","ESTADO_PRODUCCION":"PENDIENTE","TALLAS_MAQUILAS":["recnCoYHVrMJrDKuD","recgLb1fgNfigWZAA","recKkbiU41k0HACyy","recDXec5ngMhHUkv5","recbcdUkHFSyYcVrF"],"TALLER":["recsIVe0R84AyFRWf"],"COD_PRENDA":"603-0361","LOGISTICA":["recHWSP0Ufi7U0hsi"],"CANT_TOTAL":350,"ESTADO_LOGISTICA":["PENDIENTE"],"ETAPA_LOGISTICA":["PLANIFICACION"],"CLIENTE":["recG52DPkYT8e4eBk"],"CANT_MAQUILAS":350,"BARRIO":["recGzpMZFzj5VBpzC"],"FECHA_INICIO_PEDIDO":["2023-06-22"]}},{"id":"recKkKqBjpI38RRaR","createdTime":"2023-07-10T13:11:55.000Z","fields":{"INSUMOS":"**INSUMOS**\n[ ] FUNDAS\n[ ] TARJETAS\n[ ] INSTRUCCIONES\n[ ] PLASTIFLECHAS\n[ ] ADHESIVOS\n[ ] MINI HARTAG\n[ ] HILOS\n[ ] PRECIOS\n[ ] REATAS\n[ ] CIERRES\n[ ] ELASTICOS\n[ ] HILOS\n\n**CONFECCION**\n[ ] VIVOS\n[ ] DELANTEROS\n","PROYECTO":["rec1NtMQKfwFufGMg"],"TALLAS_PRODUCCION":["recuyvEb1hWAYkTQ8","receYfi11pzHQ2VuR","recKGVNzSDohMRzzQ","recNe2cRS6fgzGlqm"],"ETAPA_PRODUCCION":"03 - LOGISTICA","CODIGO":"0018027","PREPARADO":true,"FOTO_MUESTRA":[{"id":"att69QKVqe7AJF9N6","width":744,"height":539,"url":"https://v5.airtableusercontent.com/v1/20/20/1694023200000/B4wSd70Pcoe64NNi89UvPQ/i_nNaapTh-zVT2BCegupaM9ddrUMUMWGlqg9ZdrXKYVxw5MTDERtodUzwQFikeL8njcEpw3so0mqBmIo0nWuT4YpHqYPVYLQvPsj38Ve-5U/FwLha9zmLndF01bEoE2BieMo6rea7lfuOMNoM8AVpdM","filename":"0018027.jpg","size":80169,"type":"image/jpeg","thumbnails":{"small":{"url":"https://v5.airtableusercontent.com/v1/20/20/1694023200000/SeTEjaqnp5d6J71bOhu8zg/q8Su2AKPEo9BIsomHKS5wvwRMwdD7aOP46DkWKzOA-ZCzZFIyoF9dq9VoGoLWN_uJ3B49G17Owkbo6HgnkoSBA/kYSSFBaudrOnzV7xhbvP2umSiX-FcmvUVHPwcAdY0mk","width":50,"height":36},"large":{"url":"https://v5.airtableusercontent.com/v1/20/20/1694023200000/xM37jhRtjdlAGy_pYEbiVA/e_5oSVudoWiAHzNuBBDXnG77m2nYAChdCx3DizizdqNiMgjku1dkCPdf6FBUprfB0fiY7VIkiPoBxjODEnva2A/_OnX5fYw1r81uUOt0Vu-SLIgDRufXIfnQ6scahBYatU","width":707,"height":512},"full":{"url":"https://v5.airtableusercontent.com/v1/20/20/1694023200000/QgTV-zzgRPQlwSZHmUP5-A/HkYZ9pUjCceOge155TJRem0lYCrihi6J-b_BSQXbfU31B2rgWpOhsZXIrtgxQNxcgXZxZxz8m3ZYHNMsstW7yQ/yJknI10oM68FGacooC5Xe3HF4oSX7MiWo4sUCnvsva8","width":3000,"height":3000}}}],"DESCRIPCION":"ML-PL","TELA_APROBADA":true,"FECHA_ENTREGA":"2023-07-31","ESTADO_PRODUCCION":"PENDIENTE","TALLAS_MAQUILAS":["recuyvEb1hWAYkTQ8","receYfi11pzHQ2VuR","recKGVNzSDohMRzzQ","recNe2cRS6fgzGlqm"],"TALLER":["recWlqaCHk3eyESGI"],"COD_PRENDA":"101-5027","LOGISTICA":["recE8RW4bJeMVuAqb"],"CANT_TOTAL":132,"ESTADO_LOGISTICA":["PENDIENTE"],"ETAPA_LOGISTICA":["PLANIFICACION"],"CLIENTE":["recU6A98YTDdkGss4"],"CANT_MAQUILAS":132,"BARRIO":["recIz654mbKWGULxr"],"FECHA_INICIO_PEDIDO":["2023-06-23"]}},{"id":"recmNm8Ihk79HaZw9","createdTime":"2023-07-10T13:11:55.000Z","fields":{"INSUMOS":"**INSUMOS**\n[ ] FUNDAS\n[ ] TARJETAS\n[ ] INSTRUCCIONES\n[ ] PLASTIFLECHAS\n[ ] ADHESIVOS\n[ ] MINI HARTAG\n[ ] HILOS\n[ ] PRECIOS\n[ ] REATAS\n[ ] CIERRES\n[ ] ELASTICOS\n[ ] HILOS\n\n**CONFECCION**\n[ ] VIVOS\n[ ] DELANTEROS\n","PROYECTO":["reclcOMRfTuUrDyrm"],"TALLAS_PRODUCCION":["rec5ThgcsYJ4ektjE","recOuKonqzjLtJi2N","recqiNqtj5xiZsXOt","recAsvy73sEi7FMrf","receVprtUp4vjpRCt"],"ETAPA_PRODUCCION":"03 - LOGISTICA","CODIGO":"0018052","PREPARADO":true,"FOTO_MUESTRA":[{"id":"attQyyrgHw5dhs1nn","width":746,"height":528,"url":"https://v5.airtableusercontent.com/v1/20/20/1694023200000/Mm_ocL7lKWnSVjLA_PvDCA/-GdKEY0TfJndnvXqdG8zdxw-tJtUFjfEmMe9sw25En1ySONPb05YzEA6EDYwoPxcF_lrAVEM4K25oUJWLAuFt1m3Ht42908SmqBsgWM34d8/uStynhHqxeWtm4-xkyNWuDRH8l17QRVfgwdYyoKJx_M","filename":"0018052.jpg","size":80593,"type":"image/jpeg","thumbnails":{"small":{"url":"https://v5.airtableusercontent.com/v1/20/20/1694023200000/FNxYClJ0oBA7e3-QwiJi9w/tV4dvOfgacc9MhT6m3zdtSkJOWrknUhMAD0z6_AtJzjeDSBtuCBtyTiSemiomzo9xtiZEMPZxiBOj2dBkkupgA/8HjkqcUMo-M3HHCkGCWSBrT0WnHpkbALpSynPs6CM68","width":51,"height":36},"large":{"url":"https://v5.airtableusercontent.com/v1/20/20/1694023200000/P6RpAeFuZHBE0mYpH2E_GQ/BUWmKzM_zNMysrsc5auZoPE-0W8LFs3rApbObr6w1VvWB8-YDGKg5VRnzRJbBkf02v8yn7iPmbVgrD6egt72bg/JKyg2z5gE1Z8xQzdR2QGumtRswbz6gVVztBeymci488","width":723,"height":512},"full":{"url":"https://v5.airtableusercontent.com/v1/20/20/1694023200000/Z_gSWcGUEUdEOz7qjgHp0A/16mhvzobmbgo3OqmLKbB-huu8lcSPs4mjZBh_YszaVg8jggJ0zIZ9mFaMSPBjmyTaTh-vipzCjJpvcKULT8E9A/r4dKY-K7jYyf8SPPuWF2FPNm1AwYDDKNaD1Os1DcmxU","width":3000,"height":3000}}}],"DESCRIPCION":"CAMISETA CR","TELA_APROBADA":true,"FECHA_ENTREGA":"2023-09-04","ESTADO_PRODUCCION":"PENDIENTE","TALLAS_MAQUILAS":["rec5ThgcsYJ4ektjE","recOuKonqzjLtJi2N","recqiNqtj5xiZsXOt","recAsvy73sEi7FMrf","receVprtUp4vjpRCt"],"TALLER":["recFIkLGbfQ0tDh7b"],"COD_PRENDA":"606-1434","LOGISTICA":["recNKBdqk6oUIyH64"],"CANT_TOTAL":260,"ESTADO_LOGISTICA":["PENDIENTE"],"ETAPA_LOGISTICA":["PLANIFICACION"],"CLIENTE":["recEDmMlRlVGVdYks"],"CANT_MAQUILAS":260,"BARRIO":["recw8eh1wXRsygMBE"],"FECHA_INICIO_PEDIDO":["2023-06-02"]}}]}

John Fauss Accepted Answer Pending Moderation
  1. Saturday, 9 September 2023 19:49 PM UTC
  2. PowerBuilder
  3. # 1

Hi, Mario -

I was not aware there are "types" of JSON, but I admit I know little about JSON.

However, if I may offer a couple of suggestions:

1. Instead of pasting unformatted JSON, I think it would be helpful to everyone if you instead formatted the JSON. I use the "JSON Viewer" plugin to the excellent (and free) Notepad++ editor. 

2. Consider using the "Insert/Edit code sample" feature of the Q&A web site. Refer to first post shown in the Q&A home page for an explanation on how to use this very handy feature.

Please note: Since the JSON Viewer plugin uses tab characters when it formats and because the Code Sample editor in this web site insists on translating tabs to eight spaces, I replaced the tabs with two spaces in the Notepad++ editor.

The result of performing these steps is shown below:

{
  "records": [
    {
      "id": "recMZdlpJHeKpXBjd",
      "createdTime": "2023-07-10T13:11:55.000Z",
      "fields": {
        "INSUMOS": "**INSUMOS**\n[ ] FUNDAS\n[ ] TARJETAS\n[ ] INSTRUCCIONES\n[ ] PLASTIFLECHAS\n[ ] ADHESIVOS\n[ ] MINI HARTAG\n[ ] HILOS\n[ ] PRECIOS\n[ ] REATAS\n[ ] CIERRES\n[ ] ELASTICOS\n[ ] HILOS\n\n**CONFECCION**\n[ ] VIVOS\n[ ] DELANTEROS\n",
        "PROYECTO": [
          "recA6L2VX5jNILQ9k"
        ],
        "TALLAS_PRODUCCION": [
          "recnCoYHVrMJrDKuD",
          "recgLb1fgNfigWZAA",
          "recKkbiU41k0HACyy",
          "recDXec5ngMhHUkv5",
          "recbcdUkHFSyYcVrF"
        ],
        "ETAPA_PRODUCCION": "03 - LOGISTICA",
        "CODIGO": "0018024",
        "DESCRIPCION": "CAMISETA CR",
        "FECHA_ENTREGA": "2023-07-31",
        "ESTADO_PRODUCCION": "PENDIENTE",
        "TALLAS_MAQUILAS": [
          "recnCoYHVrMJrDKuD",
          "recgLb1fgNfigWZAA",
          "recKkbiU41k0HACyy",
          "recDXec5ngMhHUkv5",
          "recbcdUkHFSyYcVrF"
        ],
        "TALLER": [
          "recsIVe0R84AyFRWf"
        ],
        "COD_PRENDA": "603-0361",
        "LOGISTICA": [
          "recHWSP0Ufi7U0hsi"
        ],
        "CANT_TOTAL": 350,
        "ESTADO_LOGISTICA": [
          "PENDIENTE"
        ],
        "ETAPA_LOGISTICA": [
          "PLANIFICACION"
        ],
        "CLIENTE": [
          "recG52DPkYT8e4eBk"
        ],
        "CANT_MAQUILAS": 350,
        "BARRIO": [
          "recGzpMZFzj5VBpzC"
        ],
        "FECHA_INICIO_PEDIDO": [
          "2023-06-22"
        ]
      }
    },
    {
      "id": "recKkKqBjpI38RRaR",
      "createdTime": "2023-07-10T13:11:55.000Z",
      "fields": {
        "INSUMOS": "**INSUMOS**\n[ ] FUNDAS\n[ ] TARJETAS\n[ ] INSTRUCCIONES\n[ ] PLASTIFLECHAS\n[ ] ADHESIVOS\n[ ] MINI HARTAG\n[ ] HILOS\n[ ] PRECIOS\n[ ] REATAS\n[ ] CIERRES\n[ ] ELASTICOS\n[ ] HILOS\n\n**CONFECCION**\n[ ] VIVOS\n[ ] DELANTEROS\n",
        "PROYECTO": [
          "rec1NtMQKfwFufGMg"
        ],
        "TALLAS_PRODUCCION": [
          "recuyvEb1hWAYkTQ8",
          "receYfi11pzHQ2VuR",
          "recKGVNzSDohMRzzQ",
          "recNe2cRS6fgzGlqm"
        ],
        "ETAPA_PRODUCCION": "03 - LOGISTICA",
        "CODIGO": "0018027",
        "PREPARADO": true,
        "FOTO_MUESTRA": [
          {
            "id": "att69QKVqe7AJF9N6",
            "width": 744,
            "height": 539,
            "url": "https://v5.airtableusercontent.com/v1/20/20/1694023200000/B4wSd70Pcoe64NNi89UvPQ/i_nNaapTh-zVT2BCegupaM9ddrUMUMWGlqg9ZdrXKYVxw5MTDERtodUzwQFikeL8njcEpw3so0mqBmIo0nWuT4YpHqYPVYLQvPsj38Ve-5U/FwLha9zmLndF01bEoE2BieMo6rea7lfuOMNoM8AVpdM",
            "filename": "0018027.jpg",
            "size": 80169,
            "type": "image/jpeg",
            "thumbnails": {
              "small": {
                "url": "https://v5.airtableusercontent.com/v1/20/20/1694023200000/SeTEjaqnp5d6J71bOhu8zg/q8Su2AKPEo9BIsomHKS5wvwRMwdD7aOP46DkWKzOA-ZCzZFIyoF9dq9VoGoLWN_uJ3B49G17Owkbo6HgnkoSBA/kYSSFBaudrOnzV7xhbvP2umSiX-FcmvUVHPwcAdY0mk",
                "width": 50,
                "height": 36
              },
              "large": {
                "url": "https://v5.airtableusercontent.com/v1/20/20/1694023200000/xM37jhRtjdlAGy_pYEbiVA/e_5oSVudoWiAHzNuBBDXnG77m2nYAChdCx3DizizdqNiMgjku1dkCPdf6FBUprfB0fiY7VIkiPoBxjODEnva2A/_OnX5fYw1r81uUOt0Vu-SLIgDRufXIfnQ6scahBYatU",
                "width": 707,
                "height": 512
              },
              "full": {
                "url": "https://v5.airtableusercontent.com/v1/20/20/1694023200000/QgTV-zzgRPQlwSZHmUP5-A/HkYZ9pUjCceOge155TJRem0lYCrihi6J-b_BSQXbfU31B2rgWpOhsZXIrtgxQNxcgXZxZxz8m3ZYHNMsstW7yQ/yJknI10oM68FGacooC5Xe3HF4oSX7MiWo4sUCnvsva8",
                "width": 3000,
                "height": 3000
              }
            }
          }
        ],
        "DESCRIPCION": "ML-PL",
        "TELA_APROBADA": true,
        "FECHA_ENTREGA": "2023-07-31",
        "ESTADO_PRODUCCION": "PENDIENTE",
        "TALLAS_MAQUILAS": [
          "recuyvEb1hWAYkTQ8",
          "receYfi11pzHQ2VuR",
          "recKGVNzSDohMRzzQ",
          "recNe2cRS6fgzGlqm"
        ],
        "TALLER": [
          "recWlqaCHk3eyESGI"
        ],
        "COD_PRENDA": "101-5027",
        "LOGISTICA": [
          "recE8RW4bJeMVuAqb"
        ],
        "CANT_TOTAL": 132,
        "ESTADO_LOGISTICA": [
          "PENDIENTE"
        ],
        "ETAPA_LOGISTICA": [
          "PLANIFICACION"
        ],
        "CLIENTE": [
          "recU6A98YTDdkGss4"
        ],
        "CANT_MAQUILAS": 132,
        "BARRIO": [
          "recIz654mbKWGULxr"
        ],
        "FECHA_INICIO_PEDIDO": [
          "2023-06-23"
        ]
      }
    },
    {
      "id": "recmNm8Ihk79HaZw9",
      "createdTime": "2023-07-10T13:11:55.000Z",
      "fields": {
        "INSUMOS": "**INSUMOS**\n[ ] FUNDAS\n[ ] TARJETAS\n[ ] INSTRUCCIONES\n[ ] PLASTIFLECHAS\n[ ] ADHESIVOS\n[ ] MINI HARTAG\n[ ] HILOS\n[ ] PRECIOS\n[ ] REATAS\n[ ] CIERRES\n[ ] ELASTICOS\n[ ] HILOS\n\n**CONFECCION**\n[ ] VIVOS\n[ ] DELANTEROS\n",
        "PROYECTO": [
          "reclcOMRfTuUrDyrm"
        ],
        "TALLAS_PRODUCCION": [
          "rec5ThgcsYJ4ektjE",
          "recOuKonqzjLtJi2N",
          "recqiNqtj5xiZsXOt",
          "recAsvy73sEi7FMrf",
          "receVprtUp4vjpRCt"
        ],
        "ETAPA_PRODUCCION": "03 - LOGISTICA",
        "CODIGO": "0018052",
        "PREPARADO": true,
        "FOTO_MUESTRA": [
          {
            "id": "attQyyrgHw5dhs1nn",
            "width": 746,
            "height": 528,
            "url": "https://v5.airtableusercontent.com/v1/20/20/1694023200000/Mm_ocL7lKWnSVjLA_PvDCA/-GdKEY0TfJndnvXqdG8zdxw-tJtUFjfEmMe9sw25En1ySONPb05YzEA6EDYwoPxcF_lrAVEM4K25oUJWLAuFt1m3Ht42908SmqBsgWM34d8/uStynhHqxeWtm4-xkyNWuDRH8l17QRVfgwdYyoKJx_M",
            "filename": "0018052.jpg",
            "size": 80593,
            "type": "image/jpeg",
            "thumbnails": {
              "small": {
                "url": "https://v5.airtableusercontent.com/v1/20/20/1694023200000/FNxYClJ0oBA7e3-QwiJi9w/tV4dvOfgacc9MhT6m3zdtSkJOWrknUhMAD0z6_AtJzjeDSBtuCBtyTiSemiomzo9xtiZEMPZxiBOj2dBkkupgA/8HjkqcUMo-M3HHCkGCWSBrT0WnHpkbALpSynPs6CM68",
                "width": 51,
                "height": 36
              },
              "large": {
                "url": "https://v5.airtableusercontent.com/v1/20/20/1694023200000/P6RpAeFuZHBE0mYpH2E_GQ/BUWmKzM_zNMysrsc5auZoPE-0W8LFs3rApbObr6w1VvWB8-YDGKg5VRnzRJbBkf02v8yn7iPmbVgrD6egt72bg/JKyg2z5gE1Z8xQzdR2QGumtRswbz6gVVztBeymci488",
                "width": 723,
                "height": 512
              },
              "full": {
                "url": "https://v5.airtableusercontent.com/v1/20/20/1694023200000/Z_gSWcGUEUdEOz7qjgHp0A/16mhvzobmbgo3OqmLKbB-huu8lcSPs4mjZBh_YszaVg8jggJ0zIZ9mFaMSPBjmyTaTh-vipzCjJpvcKULT8E9A/r4dKY-K7jYyf8SPPuWF2FPNm1AwYDDKNaD1Os1DcmxU",
                "width": 3000,
                "height": 3000
              }
            }
          }
        ],
        "DESCRIPCION": "CAMISETA CR",
        "TELA_APROBADA": true,
        "FECHA_ENTREGA": "2023-09-04",
        "ESTADO_PRODUCCION": "PENDIENTE",
        "TALLAS_MAQUILAS": [
          "rec5ThgcsYJ4ektjE",
          "recOuKonqzjLtJi2N",
          "recqiNqtj5xiZsXOt",
          "recAsvy73sEi7FMrf",
          "receVprtUp4vjpRCt"
        ],
        "TALLER": [
          "recFIkLGbfQ0tDh7b"
        ],
        "COD_PRENDA": "606-1434",
        "LOGISTICA": [
          "recNKBdqk6oUIyH64"
        ],
        "CANT_TOTAL": 260,
        "ESTADO_LOGISTICA": [
          "PENDIENTE"
        ],
        "ETAPA_LOGISTICA": [
          "PLANIFICACION"
        ],
        "CLIENTE": [
          "recEDmMlRlVGVdYks"
        ],
        "CANT_MAQUILAS": 260,
        "BARRIO": [
          "recw8eh1wXRsygMBE"
        ],
        "FECHA_INICIO_PEDIDO": [
          "2023-06-02"
        ]
      }
    }
  ]
}

I encourage you and all who post questions here to do anything you individually can to help us help yourselves.

Best regards, John

Comment
  1. Francisco Martinez @Appeon
  2. Monday, 11 September 2023 15:28 PM UTC
I'm guessing OP meant the members' data types. There's no "JSON types" afaik. I agree that Mario should probably check the API documentation to verify the data types of each of the members in that response. However if for some reason that is not possible, I took the JSON and converted it to C# (using this tool https://json2csharp.com/) to see at a quick glance the members' data types
  1. Helpful 2
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Saturday, 9 September 2023 19:26 PM UTC
  2. PowerBuilder
  3. # 2

FWIW: I think that's called "check the AirTable Web API documentation".  ;-)

Comment
  1. Armeen Mazda @Appeon
  2. Saturday, 9 September 2023 23:29 PM UTC
Adding to what Chris said, I suggest asking this question to Airtable instead of PB community. They have created the Web API so they can tell you what format the JSON is and other requirements they have so you can interface with it.
  1. Helpful 2
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.