{
  "response": {
    "numFound": 1,
    "data_block": [
      {
        "Number": "11097",
        "ID": -61000,
        "Version": "18",
        "Sequence": [
          "1",
          "2",
          "3"
        ],
        "Status": [
          "Booked",
          "Canceled",
          "Canceled"
        ],
        "Name": "abc",
        "EmailAddress": "abc@test.com"
      },
      {
        "Number": "00001",
        "ID": -1000,
        "Version": "1",
        "Sequence": [
          "1"
        ],
        "Status": [
          "Booked"
        ],
        "Name": "xyz",
        "EmailAddress": "xyz@test.com"
      }

    ]
  }
}

{
  "response": {
    "numFound": 0,
    "data_block": []
  }
}

import json
from pprint import pprint
import csv

data = json.load(open('data.json'))
#data = json.load(open('data_empty.json'))
#pprint(data)

output_file_name = 'api_rspns.csv'


#create out file
f = open(output_file_name,'w')
writer = csv.writer(f,delimiter = '~')
headers = ['ORDER_NBR','ORDER_STATUS','EMAIL']
writer.writerow(headers)


print(data['response']['data_block'][0]['Number'])
print(data['response']['data_block'][0]['Status'])
print(data['response']['data_block'][0]['EmailAddress'])

print(data['response']['data_block'][1]['Number'])
print(data['response']['data_block'][1]['Status'])
print(data['response']['data_block'][1]['EmailAddress'])


#check for KeyError ,only parse if ['data_block'] present
try:
    check_key = data['response']['data_block'][0]
except KeyError:
    #continue

    for trip in check_key:
        row = []
        row.append(trip['Number'])
        #row.append(trip["Status"])
        writer.writerow(row)
f.close()