CSV Getter Docs
CSV GetterLoginSign Up
  • Welcome
  • What is CSV Getter?
  • The Export URL
  • Data Sources
    • Connect Airtable
    • Connect Notion
    • Connect Google Sheets
    • Upload Data
  • Destinations
    • Connect to Dropbox
    • Connect to Google Drive
  • Exporting
    • Export Airtable
    • Export Airtable (With Airtable URL)
    • Export Airtable (via API)
    • Export Notion
    • Export Google Sheets
    • Export Uploaded Data
  • Automations
    • Export to Excel (Windows)
    • Export to Google Sheets (Drive)
    • Export to Google Sheets (Direct)
    • Export to Dropbox
    • Export to JSON
    • Export to XML
  • Airtable
    • Linked Records and Lookup Fields
    • Export Shared Airtable View
  • Platform Features
    • URL Parameters
    • The "Type" Parameter
    • The "SQL" Parameter
    • Email Notifications
    • Extract JSON Property
    • Embeddable Wordpress HTML
  • Misc
    • Zapier Code Example
    • Google App Script Snippet
  • Custom Chat GPT Code
Powered by GitBook
On this page
  • Video Demo
  • Example:

Was this helpful?

  1. Platform Features

Extract JSON Property

Filter down JSON objects to just one value

PreviousEmail NotificationsNextEmbeddable Wordpress HTML

Last updated 5 months ago

Was this helpful?

Video Demo

Example:

Plain CSV output when extracting from CSV Getter

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.

Using the parameter

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.

Image data in Airtable
Selecting the images in the CSV Getter output