Skip to main content
Solved

Help with JSON API source

  • March 7, 2025
  • 2 replies
  • 34 views
danny.oneill

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,

Best answer by yier.wu

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

2 replies

yier.wu
Community Manager
  • yier.wu
  • Community Manager
  • 30 replies
  • Answer
  • March 7, 2025

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

danny.oneill
  • danny.oneill
  • Author
  • Guide
  • 14 replies
  • March 10, 2025

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.


Terms & ConditionsCookie settingsAccessibility statement
Huwise Terms & Conditions Cookie settings