Forum Discussion

RyanRyan4's avatar
RyanRyan4
Qrew Member
11 years ago

Using Quickbase to live update an Arcgis Online webmap

Arcgis Online is an online program capable of building a map from a CSV file containing LAT/LONG values.

We alright have a database prepared for this, but rather than export and upload the CSV manually we would like to automatically update on it's own, either through the web of as a file. So we figure we need either:

1. A Ruby script to export a table as CSV every time a row is added, overwriting the old CSV.

2. A URL that will embed a CSV of the table in a webpage.

We have tried to go about both of these methods but we have zero experience with Quickbase API and Ruby.

Has anyone ever made something similar? Perhaps someone could recommend a Quickbase partner to help us?

Thanks!

APIs and custom code
Data import and export
NotificationsEmail
  • DavidKnight's avatar
    DavidKnight
    Qrew Trainee
    7 years ago
    Curious if you (anyone) has done a successful ArcGIS Online (AGO) integration. I tried the Zapier integration but had trouble connecting to the AGO account
  • CharlesGuilbert's avatar
    CharlesGuilbert
    Qrew Member
    11 years ago
    We are a QuickBase Solutions Provider and we can assist you with this effort. If you are interested, please click on my profile and shoot us and email or give me a call.
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    11 years ago
    Arcgis supports a JavaScript API so you might be able to perform this using (1) the QuickBase API, (2) the ArcGIS API, and (3) client side JavaScript without involving Ruby or a third party server:
    ARCGIS javaScript APIhttps://developers.arcgis.com/javascript/jsapi/

    It appears that Arcgis supports JSONP which is one of two popular ways (the other being CORS) to get around the same origin policy which would normally prevent you from exchaning data between two different domains:

    ARCGIS JSONP Example https://developers.arcgis.com/javascript/jssamples/data_requestJsonp.html

    There might be a very simple solution where you call QuickBase's API to get CSV data and pump it to the appropriate Arcgis endpoint appropriately formatted.
    Contact me via the information in my profile if you need help.