Skip to main content
Solved

Downloading/Reading a dynamic spreadsheet

  • May 12, 2026
  • 2 replies
  • 27 views
db23451
Contributor
Forum|alt.badge.img+2

Hi,

I’m looking for solutions to a problem that may not be solvable.

I regularly need to refer to a spreadsheet from the NZ Electricity Authority (it’s open data).  At the moment I have to regularly download it from https://register.ea.govt.nz/ using the ‘Download’ button
 

This downloads a dynamically time-stamped spreadsheet of the electricity industry participants and their relevant codes.

I want to automate this with Form/Flow but this is a sticking point.  I’ve suggested to them that they expose this as a service for the industry, but the wheels move slowly if at all.

Any idea on how to read, or more likely, automatically download this?  For the download I’m open to non-FME automations.

Thanks

Best answer by hkingsbury

All that link is doing is making a call to “https://register.ea.govt.nz/download?”

You may be able to replicate the call in the HTTPCaller, you may need to adjust some of the headers to pass through what the end point is expecting.

You can find these using your browsers developer tools

2 replies

hkingsbury
Celebrity
Forum|alt.badge.img+70
  • hkingsburyCelebrity
  • Celebrity
  • Best Answer
  • May 13, 2026

All that link is doing is making a call to “https://register.ea.govt.nz/download?”

You may be able to replicate the call in the HTTPCaller, you may need to adjust some of the headers to pass through what the end point is expecting.

You can find these using your browsers developer tools

db23451
Contributor
Forum|alt.badge.img+2
  • db23451Contributor
  • Author
  • Contributor
  • May 13, 2026

That works.  Thanks Hamish

Community Stats

32,555
Posts
123,616
Replies
40,810
Members
Terms & ConditionsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.