Connect Colorado Information Marketplace to JigsawStack

Both apps 28Colorado Information Marketplace 5JigsawStack 23

• Trigger
  New record

  Polling trigger: fires when a new row appears in a specified Colorado Information Marketplace (Socrata SODA API) dataset. GET https://data.colorado.gov/resource/{dataset_id}.json ordered by a rowid/created/updated system field ($order=:id DESC or an updated_at column) with $limit, dedup by the row's system id (:id) or an updated_at watermark since datasets vary in whether they expose a stable update timestamp column.

• Action
  Find datasets

  Search the Colorado Information Marketplace open-data catalog for datasets by keyword/category. GET https://data.colorado.gov/api/catalog/v1?q={query}&limit=... (Socrata Discovery API) returning dataset id, name, description, category, and update timestamps. Used to locate the dataset identifier that other ops (List/Get/Find records) require as input.

• Action
  Find records by criteria

  Query a Colorado Information Marketplace (Socrata SODA API) dataset with a SoQL $where/$select/$order filter. GET https://data.colorado.gov/api/v3/views/{dataset_id}/query.json (or resource/{dataset_id}.json on older SODA2 endpoints) with SoQL query params ($where, $select, $order, $limit, $offset). Requires the dataset identifier (8-char alphanumeric, e.g. ydr8-5enu) as input plus the SoQL clauses.

• Action
  Get record

  Get a single row from a Colorado Information Marketplace (Socrata SODA API) dataset by its row identifier. GET https://data.colorado.gov/resource/{dataset_id}/{row_id}.json (or a $where=:id='{row_id}' query when the dataset has no explicit row identifier). Requires dataset_id and row_id.

• Action
  List records

  List all rows in a Colorado Information Marketplace (Socrata SODA API) dataset, paginated. GET https://data.colorado.gov/resource/{dataset_id}.json with $limit/$offset params. Requires the dataset identifier (8-char alphanumeric, e.g. ydr8-5enu).

• Action
  Add file

  Uploads a file to JigsawStack file storage. Endpoint: POST /store/file.

• Action
  Add prompt

  Creates a reusable AI prompt template in the Prompt Engine. Endpoint: POST /prompt_engine.

• Action
  Classify text

  Classifies input text/data against provided or inferred labels. Endpoint: POST /classification.

• Action
  Convert HTML

  Converts HTML content to another format (e.g. PDF/image). Endpoint: POST /web/html_to_any.

• Action
  Delete file

  Deletes a stored file by key. Endpoint: DELETE /store/file/read/{key}.

• Action
  Delete prompt

  Deletes a Prompt Engine template by id. Endpoint: DELETE /prompt_engine/{id}.

• Action
  Generate embedding

  Generates a vector embedding for input text/image. Endpoint: POST /embedding.

• Action
  Generate SQL

  Converts a natural-language prompt into a SQL query. Endpoint: POST /ai/sql.

• Action
  Get prompt

  Retrieves a Prompt Engine template by id. Endpoint: GET /prompt_engine/{id}.

• Action
  NSFW

  Quickly detect nudity, violence, hentai, porn and more NSFW content in images.

• Action
  Object Detection

  Recognise objects within an image with great accuracy.

• Action
  Profanity

  Check any text for profanity.

• Action
  Run prompt

  Executes a saved Prompt Engine template with runtime inputs. Endpoint: POST /prompt_engine/run.

• Action
  Scrape webpage

  Scrapes structured content/data from a given URL. Endpoint: POST /ai/scrape.

• Action
  Search web

  Runs a web search query and returns ranked results. Endpoint: POST /web/search.

• Action
  Sentiment Analysis

  Perform sentiment analysis on a given text.

• Action
  Spam Check
• Action
  Speech to Text

  Transcribe video and audio files with ease leveraging Whisper large V3 AI model.

• Action
  Spell Check

  Check and correct spelling errors in a text.

• Action
  Summary

  Generate smarter text summaries with AI

• Action
  Translate

  Translate text from one language to another.

• Action
  Translate image

  Translates text found within an image to a target language. Endpoint: POST /ai/translate/image.

• Action
  vOCR

  Recognise, describe and retrieve data within an image with great accuracy.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.