Connect SQL Server to Geocode.xyz

Both apps 16SQL Server 11Geocode.xyz 5

• Trigger
  New or Updated Row

  Triggers when a new row is added or modified.

• Trigger
  New or Updated Row (Custom Query)

  Fires for each new or changed row returned by a SELECT statement you write against the connected SQL Server database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected SQL Server database.

• Action
  Add Row

  Add one row to a table on the connected SQL Server database.

• Action
  Delete Row

  Delete the rows in a table whose chosen column equals a value.

• Action
  Find Row

  Find the first row in a table whose chosen column matches a value.

• Action
  Find Rows via Custom Query

  Runs a SELECT statement you write against the connected SQL Server database and returns every row it matches.

• Action
  Find Row via Custom Query

  Runs a SELECT statement you write against the connected SQL Server database and returns the first row it matches.

• Action
  Run Custom Statement

  Runs a statement you write against the connected SQL Server database that changes data rather than returning rows, and reports how many rows it changed.

• Action
  Update Row

  Change column values on every row of a table whose chosen column matches a value.

• Action
  Autocomplete address

  Get street name, city, and postal code suggestions for a partial street name, city name, or postal code within a given region. GET https://geocode.xyz/?region={region}&streetname={partial}&cityname={partial}&geoit=json

• Action
  Geocode address

  Convert a street address, postal code, landmark, or city name into latitude/longitude coordinates (forward geocoding). GET https://geocode.xyz/?locate={address}&json=1

• Action
  Geolocate IP address

  Look up the approximate physical location of an IP address. GET https://geocode.xyz/?locate={ip_address}&json=1

• Action
  Geoparse text

  Scan a block of free text and extract every place name mentioned, geocoded to coordinates and ordered by match confidence. POST https://geocode.xyz/ with scantext={text}&json=1

• Action
  Reverse geocode coordinates

  Convert a latitude,longitude point into the nearest street address description (reverse geocoding). GET https://geocode.xyz/?locate={lat},{lng}&json=1

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