Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved How to identify wath type of JSON

  1. How-to
0
Votes
Undo
  1. Mario Francisco Celleri
    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"]}}]}

How to know query datatype
changing dataobject of a datawindow
Responses (3)
Mario Francisco Celleri
Mario Francisco Celleri Accepted Answer Pending Moderation
  1. Thursday, 27 June 2024 21:00 PM UTC
  2. PowerBuilder
  3. # 1

I still checking the AirTable API.

Comment
There are no comments made yet.
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Saturday, 9 September 2023 19:49 PM UTC
  2. PowerBuilder
  3. # 2

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
Francisco Martinez @Appeon
  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
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Saturday, 9 September 2023 19:26 PM UTC
  2. PowerBuilder
  3. # 3

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

Comment
Armeen Mazda @Appeon
  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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.