AnsweredAssumed Answered

Can't get JSONListKeys to work for me

Question asked by nathanwilcox on Apr 25, 2018
Latest reply on Apr 25, 2018 by jfencil

Hi All,

 

I've been working on getting an automated result of records from an API that lists food recalls for products in the UK.

 

I've tried to follow the example to create new records based on JSON results used on FileMaker Pro 16 Help which explains FM16 JSON Functions.

 

My script works to call on the API and get results, but it fails at the "JSONListKeys" section. Can someone take a look and tell me where I'm going wrong please?

 

The JSON Result can be found here: http://data.food.gov.uk/food-alerts/id?_limit=2  I've limited it to 2 results for an example.

 

My Script is currently this:

Screen Shot 2018-04-25 at 22.45.15.png

 

Is there something obvious that I'm missing?

 

Thanks

Nathan

Outcomes