Skip to main content
Question

How to use HTTPCaller or another transformer to query and download data from Washington State Patrol Collision Analysis Tool.

  • October 21, 2020
  • 1 reply
  • 10 views
durshe80

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.

redgeographics
Celebrity
Forum|alt.badge.img+49

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


Helpful Members This Week

Community Stats

31,031
Posts
117,602
Replies
38,810
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.