Extract JSON Property
Filter down JSON objects to just one value
Last updated
Filter down JSON objects to just one value
Last updated
i.e https://api.csvgetter.com/abc123
Output
Name,Logo
DIME Design,"{'id': 'attG3envSxjOYXLgR', 'width': 622, 'height': 345, 'url': 'https://v5.airtableusercontent.com/v3/u/35/35/1731412800000/S-6HjeAiH7ruFAmezqrv-w/jQxzLFbjd3-tsPao7SZpNP602GrnHvBZpo16sHyvmE0tNY2sCzV2f3QEr-aQZbjYEHDZf3rLAKu5a8DdS51SlCX3LF4jKHdB58rmB-_bldOGU4XLWWQjQUUsQn6c58mpk3JIhy4ainjXlKiADeSFSRljnQW5vsT-VWctCkX-2wU/SXbF2zw0ID-2UbmDcJv3ih6PyZjMLq-v8QGuFvt14qo', 'filename': 'Screen Shot 2019-06-27 at 3.53.39 PM.png', 'size': 27944, 'type': 'image/png', 'thumbnails': {'small': {'url': 'https://v5.airtableusercontent.com/v3/u/35/35/1731412800000/qpK0RjX_z1Al5Wweu41QFg/zp2QIsQqpLdPKT5512n3VyYsLNtVc8ivv6infoU1RPK-yTgiCEbrPqXPizmIrtJw30SoJGGPBVOC9vRERi8nXZ4cnlSWNBhUbAkGKQKchbZ9jOyYU_b5FY5mMO-AA03Xl1hfTjr854gBK1BZOBxajw/fALvBKdeDKccQAg5JxwuouEOIjZhV6nDx5cIdU6psXE', 'width': 65, 'height': 36}, 'large': {'url': 'https://v5.airtableusercontent.com/v3/u/35/35/1731412800000/Fko04Bn4FV5rIPuGg1UhrQ/LJ60Ln7MCDOnBGsiSU4MMS62PLvg2jROYyyiJBTkFINonCaiAWvWNz7LuUxPD7NC59OrXAdKGf-EKI2zm6aku5GNEvJGqduaV60uknPa63mO87S-wTM7-3OPfqauSvSULTThFkofSZEUFYGnsV-Dng/eKKrjBaTTwtVg9VVjp3R-15TU4aFJ7D8oK9JjSrbS1o', 'width': 622, 'height': 345}, 'full': {'url': 'https://v5.airtableusercontent.com/v3/u/35/35/1731412800000/lWz6bP82dy096wNCpQupZQ/WxHHiNsonrhyaN2wg9xUDJc63_GMqWL1HPolT9xygzNv51TNLpQV3HjXlsbeSiI8tVtWZtwNSyk19efdkGbro5TVV7MuAED0I-4W4V2wU5DZ8OTNPK_Tu-IIZRbgteB12KOuVFH1SWGqMNmLsPFsTA/L3ycygUjcAVV1V-T0cpG9CKJUdDFEiFcMmN4qNHpfb4', 'width': 3000, 'height': 3000}}}"
box + cask,"{'id': 'attpN8QBM2HcvjluY', 'width': 337, 'height': 297, 'url': 'https://v5.airtableusercontent.com/v3/u/35/35/1731412800000/TxnpiyG7nsMStDf0C-6UEg/ZH6ts6-rzwYoKg7x8dNJ_k3OirPjV-N6QNwR2JmUzrKkKgxR_yhojbcOo381wiAeAM5peE8Mhv21SyIlsuMjZ8h5A180uw0OVeWHngWdhoNuTS_CLRDUSkh9upFWDHEr73YpHKQ-jshJ95rfmlxrhZYI4Zf5qdP9INkenv_kFLI/-yUYaNuJAutA5E_O6W88vPIaLyDllGvC5NN-GDRdb2Y', 'filename': 'Screen Shot 2019-06-27 at 4.01.28 PM.png', 'size': 19214, 'type': 'image/png', 'thumbnails': {'small': {'url': 'https://v5.airtableusercontent.com/v3/u/35/35/1731412800000/hjZAtzdEsb9Jvti754yCLQ/ztK_2EQ8yGqwzlTb69wePmq8tg28Bpg1_2yzP-sls322FqCnER2fy0m-F5n15F4K8Voy98o2WD0PAdJcTo0RCNNuouJDteW2TiG6rw5yVxoWhJdolsXAyriIy0CjQJPqjXseclinSGAioQw40G2rwA/GTiLqSIghEGqdPnzUvggusBydLU9gwnRrzuyJkf7sY0', 'width': 41, 'height': 36}, 'large': {'url': 'https://v5.airtableusercontent.com/v3/u/35/35/1731412800000/cYALfoJPyJav0rboy5yK8g/tmspiKxPMGJf3tPdp1mfBYXsdHRHQK6CmTpQUMwY0NhS-MweozvFHP86KdrMymydwHq4idRIdc8mYYvu6zsho_ynka1UGV1sUXz4eFFa-qMqSjVDWyvhSjTZ5DMUyMHHLw52e6kWdELZE5Bl-GGw0g/e6VItr_5gBdNqeluT5_quy51m2STtRes0lpWG6snQvs', 'width': 337, 'height': 297}, 'full': {'url': 'https://v5.airtableusercontent.com/v3/u/35/35/1731412800000/H-MN7Si93CrudgwpTU4MCw/du_lsHll9ZpW_9PwY86EeX_DCbKo7y9TpAKjY83Pt3C7I_TNLO2sQ5RfvnF5DYdIKeUUOqRtNU4uZ9KQbOucM08IadzEjDryRRgzZ8X2Ntox0vTsJ8j9LnkT5HuOfrlDPwOF8aFcXlu3C9cXaOhfCQ/7-a7UHPVpfY44TKtVJc55HhyuOimrL4BKrGo4NNMHhI', 'width': 3000, 'height': 3000}}}"
The above output can occur when images and other assets are extracted from Airtable.
i.e https://api.csvgetter.com/abc123
?extract_json_property=url
Output
Name,Logo
DIME Design,https://v5.airtableusercontent.com/v3/u/35/35/1731412800000/S-6HjeAiH7ruFAmezqrv-w/jQxzLFbjd3-tsPao7SZpNP602GrnHvBZpo16sHyvmE0tNY2sCzV2f3QEr-aQZbjYEHDZf3rLAKu5a8DdS51SlCX3LF4jKHdB58rmB-_bldOGU4XLWWQjQUUsQn6c58mpk3JIhy4ainjXlKiADeSFSRljnQW5vsT-VWctCkX-2wU/SXbF2zw0ID-2UbmDcJv3ih6PyZjMLq-v8QGuFvt14qo
box + cask,https://v5.airtableusercontent.com/v3/u/35/35/1731412800000/TxnpiyG7nsMStDf0C-6UEg/ZH6ts6-rzwYoKg7x8dNJ_k3OirPjV-N6QNwR2JmUzrKkKgxR_yhojbcOo381wiAeAM5peE8Mhv21SyIlsuMjZ8h5A180uw0OVeWHngWdhoNuTS_CLRDUSkh9upFWDHEr73YpHKQ-jshJ95rfmlxrhZYI4Zf5qdP9INkenv_kFLI/-yUYaNuJAutA5E_O6W88vPIaLyDllGvC5NN-GDRdb2Y
With the extract_json_property value, the CSV output will not contain JSON data and will pull 'url' from each json object instead.