Forum Discussion

alicek's avatar
alicek
Helper III
4 years ago
Solved

Using SQL query to pre-filter what Socrata OData feed pulls in not working

Hi all,    I want to connect to this Open Data Portal run by Socrata from the EDD: https://data.edd.ca.gov/Industry-Information-/Quarterly-Census-of-Employment-and-Wages-QCEW-/fisq-v939/data#revert...
Need Help
Tutorial Requests
  • alicek's avatar
    alicek
    4 years ago

    Oh man, I solved my own problem by learning more SQL than I ever knew! For anyone who searches the same key words because they're having the same problem.... here is the solution:

    Connect to the V2 endpoint of the OData feed. Then use the right SQL language (I was not using it!). See bolded below:
    = OData.Feed("https://data.edd.ca.gov/OData.svc/fisq-v939?$filter=year gt 2020 and area_name eq 'San Francisco County'", null, [Implementation="2.0"])

alicek's avatar
alicek
Helper III
4 years ago

Oh man, I solved my own problem by learning more SQL than I ever knew! For anyone who searches the same key words because they're having the same problem.... here is the solution:

Connect to the V2 endpoint of the OData feed. Then use the right SQL language (I was not using it!). See bolded below:
= OData.Feed("https://data.edd.ca.gov/OData.svc/fisq-v939?$filter=year gt 2020 and area_name eq 'San Francisco County'", null, [Implementation="2.0"])