Connect SQL Server to RentCheck

Both apps 31SQL Server 11RentCheck 20

• 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
  Add Building

  Create a building.

• Action
  Add Community

  Create a community.

• Action
  Add Maintenance report

  Create a maintenance report.

• Action
  Create Inspection

  Create Inspection

• Action
  Create Property

  Creates a new property. A default room configuration is applied based on the property type (single-family or multi-family).

• Action
  Create Resident

  Create resident

• Action
  Delete Inspection

  Deletes an inspection by its ID.

• Action
  Delete Property

  Delete one or more units/properties.

• Action
  Delete Resident

  Delete a resident by ID.

• Action
  Get Building

  Fetch a building by ID.

• Action
  Get Community

  Fetch a community by ID.

• Action
  Get Inspection

  Retrieves a single RentCheck inspection by its ID.

• Action
  Get Maintenance report

  Get a maintenance report by its ID.

• Action
  Get Property

  Retrieves a single property (unit) by its ID.

• Action
  Get Resident

  Fetch a resident by ID.

• Action
  List Properties

  Lists the properties (units) in the RentCheck account, optionally filtered by address, team, sync status or last completed inspection date.

• Action
  Submit Inspection

  Submits a performed inspection for review, moving it out of In Progress and notifying reviewers.

• Action
  Update Inspection

  Update an inspection by ID.

• Action
  Update Property

  Updates an existing property (unit) in RentCheck. Only the fields you fill in are changed.

• Action
  Update Resident

  Updates a resident's name, emails, phone numbers or organization in RentCheck.

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