Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Integration
  • How to use HTTPCaller or another transformer to query and download data from Washington State Patrol Collision Analysis Tool.

I would like to see if anyone can help me figure out a way to export data from https://fortress.wa.gov/wsp/collisionanalysistool/Query/SearchCriteria site using either HTTPCaller with JSON... or another series of transformers.

This site allows us to select collision data based on some criteria and then export that data out to excel/csv. I have requested the API reference to this, but have not yet received it, and am not sure if I will.

Ultimately I would like to automate a process that downloads most current data on a monthly basis then adds that data to a GIS layer.

It seems very doable; but not being a web developer, I can only get so far trying to understand what's going on using developer tools in Chrome/Edge.

When using HTTPCaller, the response body looks promising, but I can't seem to get past that.

Any help would be greatly appreciated.

Let me start by saying an API would by far be the easiest option.

 

The form does a HTTP Post to a certain address (look at the source and check the <form> tag for that) so you could try building the URL for that manually and sending that through the HTTPCaller. Check for the various form items you want to include by looking for <select> tags and the corresponding <option> values, or <input> tags for free-form text fields.

There is a chance you won't get through, authentication might be in place, or the format might just be wrong. If it's not meant to be used in this way and it's not documented it's going to be tricky.

 

Now I can't help but look for the collisions with unicyclists 😂

Reply


Community Stats

30,194
Posts
114,613
Replies
37,856
Members
Terms & ConditionsCookie settings
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.