Skip to main content

Hi, Im really struggling to get the JSON processor to work with https://api.carbonintensity.org.uk/regional

I think I have it pulling in correctly but when I try and extract using the JSON processor using Extract from JSON or Expand JSON array it isnt populating the field. 

I’ve re-read the academy docs and asked ChatGPT but nothing is working in the output. 

Many Thanks,

Hello Danny,

I tried myself with the url and by using the processors you mentioned with the logic below so to populate all fields

  1. Expand JSON array : regions → regions_expanded
  2. Extract from JSON : regions_expanded → regionid, dnoregion, shortname … 
  3. Expand JSON array : generationmix → generationmix_expanded
  4. Extract from JSON : generationmix_expanded → fuel, perc

Here are the configurations of the processor :

 

 

I hope this will help. 

Yier

Thank you ​@yier.wu . I dont know why I couldnt see it but this was the answer and now I have it working. Incredible work my man.

Reply


Terms & ConditionsCookie settings
Opendatasoft Terms & Conditions Cookie settings