What is the advantage of using the Socrata web connector over the OData connectors provided with datasets?
1 of 1 people found this helpful
According to the Tableau docs on OData, OData can't be refreshed.
After you connect to an OData data source, you will be prompted to Import the data into Tableau's data engine (see Extracting Data). Unlike many extract connections, extracts from OData data sources cannot be refreshed. To get the updated data, you must reconnect to the data source.
For SODA you could use the API to have fresh data extractions. Handy for frequently updated data like Crime report/police reports that are updated daily. For annual data or one time reports it probably wouldn't matter.
I'm having trouble getting this to work. It seems to have to do with line 67 in the Socrata sample connector:
var connectionUrl = connectionData.url + '?%24limit=100&$offset=' + lastRecordToken;
Could you please explain the purpose of this line? What do you recommend setting the offset to?