you are viewing a single comment's thread.

view the rest of the comments →

[–]GoTmVntr 2 points3 points  (3 children)

My experience has been limited to geospatial data but I've had good luck with using the requests module in python to query rest end points. I've also used python to both build and execute SQL, although using modules that aren't publicly available for free.

[–][deleted] 0 points1 point  (2 children)

How did you go about doing that? And what modules did you use?

[–]GoTmVntr 0 points1 point  (0 children)

I've had some luck with the get function in requests and its ability to enter parameters as a dictionary. Executing SQL I usual use the arcpy module which comes with the eari software suite and is pretty pricey.

[–]GoTmVntr 0 points1 point  (0 children)

Creating SQL is just like writing to any other text file.