Connect Accredible Certificates and SQL Server

Both apps 22Accredible Certificates 11SQL Server 11

• Trigger
  New Credential Published

  Triggers when a credential (certificate or badge) is published in Accredible, optionally limited to one group or recipient.

• Action
  Add evidence item

  Adds an evidence item (a file, link, video, grade or transcript) to an existing credential so it is shown on the recipient's certificate or badge page.

• Action
  Add reference

  Adds a reference (a testimonial from a teacher, manager, mentor or colleague) to an existing credential.

• Action
  Create Evidence - Transcript

  Adds a transcript to a credential as an evidence item, shown on the recipient's certificate or badge.

• Action
  Delete Credential

  Deletes a credential (certificate or badge) from your Accredible account and returns the record that was removed.

• Action
  Delete group

  Deletes a group (a course or achievement) from your Accredible account and returns the deleted group.

• Action
  Find Credentials

  Returns the credentials that match the criteria you supply, such as recipient email, recipient name, group, or issue date range.

• Action
  Generate credential PDF

  Generates a PDF of a published credential and returns a link to download it.

• Action
  Get credential

  Returns one credential by its id, including its recipient, group, custom attributes, evidence, references, skills and image links.

• Action
  Get group

  Returns a group (a course or achievement) with its course details, design, collections, earning criteria and skills.

• Action
  List credentials

  Returns every credential in your Accredible account, oldest first, optionally narrowed to one group, a publish state, a recipient or a date range.

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