View as Markdown
ArcGIS Online icon

ArcGIS Online ACTION

Search by Column

Search for features in a layer where a field matches a value. Builds a WHERE field = 'value' query with SQL-escaped single quotes. Returns matching features as a flat array of attribute objects (no geometries). See the documentation
  • Action
  • Read only
  • OAuth
  • SDK
  • MCP

IMPLEMENTATION

Call this tool

Connect a user's ArcGIS Online account once, then configure and run Search by Column from your backend or agent.

import { PipedreamClient } from "@pipedream/sdk"

const pd = new PipedreamClient({
  projectId: process.env.PIPEDREAM_PROJECT_ID!,
  clientId: process.env.PIPEDREAM_CLIENT_ID!,
  clientSecret: process.env.PIPEDREAM_CLIENT_SECRET!,
  projectEnvironment: "production",
})

const result = await pd.actions.run({
  id: "arcgis_online-search-by-column",
  externalUserId: "{external_user_id}", // any stable ID for this user in your system
  configuredProps: {
    arcgis_online: { authProvisionId: "apn_xxxxxxx" },
    featureService: "Feature Service",
    layerId: "Layer",
  },
})

console.log(result)

SCHEMA

Inputs

Pipedream supplies the connected account. Your application provides the operation-specific values below. Dynamic inputs are resolved against that user's account.

Search by Column inputs
Property Type Description
featureService Feature Service string
The Feature Service to use: a 32-character portal item ID (e.g. "0123456789abcdef0123456789abcdef"), a full FeatureServer URL (e.g. "https://services.arcgis.com/.../FeatureServer/0"), or a service title that matches search results
Required Dynamic
layerId Layer string
Layer in the Feature Service: numeric layer id as a string (e.g. "0" or "1") or layer name (e.g. "Parcels"); names are matched case-insensitively
Required Dynamic
fieldName Field Name string
Layer attribute field name (e.g. "OBJECTID", "CITY_NAME"). Names are case-sensitive and must match the layer schema
Required Dynamic
searchValue Search Value string
Value to match against the selected field. Compared with exact string equality; numeric fields may coerce depending on the service
Required

REFERENCE

Tool details

Behavior hints are published with the component in the Pipedream registry and surface as MCP tool annotations, so an agent can reason about a tool before it calls it.

Registry key
arcgis_online-search-by-column
Version
0.1.2
App
ArcGIS Online
Authentication
OAuth
Read-only
Yes
Destructive
No
Open world
Yes