API Help

[Ray Cote]

On Wed, Jun 14, 2017 at 4:33 PM, Bradley Cooper <brad at midwestaftermarket.com
> wrote:

> I am working with an API and I get a return response in this format.
>
>
> [{"itemNumber":"75-5044","inventory":[{"warehouseCode":"
> UT-1-US","quantityAvailable":0.0000000000000},{"warehouseCode":"KY-1-US","
> quantityAvailable":0.0000000000000},{"warehouseCode":"TX-1-US","
> quantityAvailable":14.0000000000000},{"warehouseCode":"CA-1-US","
> quantityAvailable":4.0000000000000},{"warehouseCode":"AB-1-CA","
> quantityAvailable":1.0000000000000},{"warehouseCode":"WA-1-US","
> quantityAvailable":0.0000000000000},{"warehouseCode":"PO-1-CA","
> quantityAvailable":0.0000000000000}]}]
>
> What is the best way to read through the data?
>

Definitely JSON:
>>>
json.loads(“""[{"itemNumber":"75-5044","inventory":[{"warehouseCode":"UT-1-US","quantityAvailable":0.0000000000000},{"warehouseCode":"KY-1-US","quantityAvailable":0.0000000000000},{"warehouseCode":"TX-1-US","quantityAvailable":14.0000000000000},{"warehouseCode":"CA-1-US","quantityAvailable":4.0000000000000},{"warehouseCode":"AB-1-CA","quantityAvailable":1.0000000000000},{"warehouseCode":"WA-1-US","quantityAvailable":0.0000000000000},{"warehouseCode":"PO-1-CA","quantityAvailable":0.0000000000000}]}]""")

[{u’itemNumber': u'75-5044', u'inventory': [{u'quantityAvailable': 0.0,
u'warehouseCode': u'UT-1-US'}, {u'quantityAvailable': 0.0,
u'warehouseCode': u'KY-1-US'}, {u'quantityAvailable': 14.0,
u'warehouseCode': u'TX-1-US'}, {u'quantityAvailable': 4.0,
u'warehouseCode': u'CA-1-US'}, {u'quantityAvailable': 1.0,
u'warehouseCode': u'AB-1-CA'}, {u'quantityAvailable': 0.0,
u'warehouseCode': u'WA-1-US'}, {u'quantityAvailable': 0.0,
u'warehouseCode': u'PO-1-CA'}]}]
>>>

-- 
Raymond Cote, President
voice: +1.603.924.6079 email: rgacote at AppropriateSolutions.com skype:
ray.cote
Schedule a meeting: https://calendly.com/ray_cote/60min/