Connect Oracle Database to Minor Planet Center

Both apps 23Oracle Database 12Minor Planet Center 11

• Trigger
  New Column

  Fires when a new column appears on an Oracle table you choose.

• 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 Oracle database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected Oracle user's own schema.

• Action
  Add Row

  Add one row to a table on the connected Oracle 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 Oracle database and returns every row it matches.

• Action
  Find Row via Custom Query

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

• Action
  Run Custom Statement

  Runs a statement you write against the connected Oracle 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
  Find MPECs

  Search Minor Planet Electronic Circulars by object or search terms, optionally filtered by issue date range (data.minorplanetcenter.net/api/mpecs).

• Action
  Find near-duplicate observations

  Search the MPC's published observation database for near-duplicates of a given observation by time and angular proximity (data.minorplanetcenter.net/api/cnd).

• Action
  Get action code

  Resend an observation submission's action code (used to retract observations or label objects) to the email address on file (data.minorplanetcenter.net/api/action-codes/retrieve).

• Action
  Get magnitude band

  Retrieve reference information for a magnitude band used in MPC observations, or all bands (data.minorplanetcenter.net/api/mag-band).

• Action
  Get NEOCP observations

  Retrieve observation data for an object currently on the Near-Earth Object Confirmation Page by tracklet identifier (data.minorplanetcenter.net/api/get-obs-neocp).

• Action
  Get object identifier

  Look up the designations and identification details for a minor planet or comet given a name, provisional or permanent designation (data.minorplanetcenter.net/api/query-identifier).

• Action
  Get observations

  Retrieve recorded astrometric observation data for a solar system object by designation (data.minorplanetcenter.net/api/get-obs).

• Action
  Get observation status

  Check the processing status of individual submitted observations by tracklet/station, observation ID, obs80 string, or submission block ID (WAMO — data.minorplanetcenter.net/api/wamo).

• Action
  Get observatory codes

  Retrieve details for one or all observatories registered with the MPC by observatory code (data.minorplanetcenter.net/api/obscodes).

• Action
  Get orbital elements

  Retrieve orbital elements and related parameters for a solar system object by designation (data.minorplanetcenter.net/api/get-orb).

• Action
  List objects

  List solar system objects belonging to a named group such as NEOs, comets, or TNOs, ordered by designation (data.minorplanetcenter.net/api/list).

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