Connect Federal Register to SQL Server

Both apps 19Federal Register 8SQL Server 11

• Trigger
  New document

  Polling trigger that fires when a new Federal Register document is published, using GET /documents.{format} sorted by publication_date descending as the dedup source for regulatory monitoring.

• Action
  Find documents

  Search all Federal Register documents published since 1994 by term, agency, document type, publication/effective date, and docket number. Endpoint: GET /documents.{format}

• Action
  Find public inspection documents

  Search public inspection documents currently scheduled for future publication. Endpoint: GET /public-inspection-documents.{format}

• Action
  Get agency

  Fetch a particular agency's details by slug. Endpoint: GET /agencies/{slug}

• Action
  Get document

  Fetch a single Federal Register document by document_number, returning its full text and metadata. Endpoint: GET /documents/{document_number}.{format}

• Action
  Get issue

  Fetch a document table of contents for the print edition based on publication_date. Endpoint: GET /issues/{publication_date}.{format}

• Action
  Get public inspection document

  Fetch a single public inspection document by document_number. Endpoint: GET /public-inspection-documents/{document_number}.{format}

• Action
  List agencies

  Fetch all agency details known to the Federal Register. Endpoint: GET /agencies

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

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