Dela via


CobbleStone Contract Insight (Preview)

The Cobblestone - Contract Insight connector allows you to connect our contract management software with many popular web and data services. The basic out of the box (OOB) endpoints will allow you to review Schema table names and whether they can be searched, edited, and updated. You can pull Entity information on table names, and Query, add, and update Customer record data.

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure Government regions
     -   Azure China regions
     -   US Department of Defense (DoD)
Power Automate Premium All Power Automate regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Power Apps Premium All Power Apps regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Contact
Name CobbleStone Team
URL https://www.cobblestonesoftware.com
Email mefriebis@cobblestonesystems.com
Connector Metadata
Publisher Cobblestone Software
Website https://www.cobblestonesoftware.com
Privacy Policy https://www.cobblestonesoftware.com/company/privacy-policy
Categories Business Management;Sales and CRM

CobbleStone

Allows the basic operations against our Contract Insight software (Add, Insert, Update) and schema information for an entity.

Publisher: CobbleStone Software

Prerequisites

Requires existing license to CobbleStone Software (Contact Insight).

Supported Operations

Get

Pull list of records for a given entity with specific criteria, order by tag, group by tag and number of records. Note: There is no limit on number of records to be pulled but the user has to consider that larger results will be slower to process.

Add

Add a record (limited to one record per call) to specified entity. The response will be the system generated ID.

Update

Update record(s) for a specified entity/area with specific criteria and a TriggerWorkflow as flag to run workflow after the update request succeeds or not. Maximum number of records that can be updated is 500 per call.

Schema

Lists columns, data types, and any restrictions or flags (NULL, Length, Primary Key, etc.) in a table.

List of entities

Returns the list of names and three flagged properties indicating whether it can be edited, updated, or viewed/queried through this interface.

Obtaining Credentials

Authorization (OAUTH 2.0)

Credentials can be setup/generated through your CobbleStone Software system.

Getting Started

To create the API Client credentials through your CobbleStone Software system, use the following steps:

Within your CobbleStone Software system, a system administrator can navigate to the following page to setup/configure credentials:

(NOTE: This is under the "My" top menu item and then select "My API Clients")

This allows a system admin to create OAuth 2.0 credentials (Client ID and Client Secret) for use with the connector.

From logging into your CobbleStone Software system:

To begin, you will open CobbleStone Software and go under My > My API Clients…

image1

Create a new API Client entry by clicking Add API Client and give it a unique name. The name is only internal and can be anything meaningful to its purpose. We recommend using a different API key to organize things into small, manageable, and purposeful tasks.

image2

This will generate a key and only admin personnel have access to the page. It is bound the the person who generated the key and they are the only one who can see it. You can share they key but only the logged in user can see it.

image3

At this point we are done setting up the API Client entry. This Client ID and Client Securet are used for the connector to communicate with your CobbleStone Software system.

Known Issues and Limitations

Currently the connector does not support sending or receiving binary files.

The "Update" endpoint is limited to a max of 500 affected rows per hit. If more then 500 records need to be updated, they need to be processed in multiple hits.

Creating a connection

The connector supports the following authentication types:

Default Parameters for creating connection. All regions Not shareable

Default

Applicable: All regions

Parameters for creating connection.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Name Type Description Required
Client Id - Your CobbleStone ClientId string Please enter the client Id. True
Client Secret - Your CobbleStone ClientSecret securestring Please enter the client secret. True
Authorization URL string Please enter the Authorization URL. True
Token URL string Please enter the Token URL. True
Refresh URL string Please enter the Refresh URL. True
Scopes string Please enter the scopes. True

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Actions

Create a new a record for a specified entity

Add a record (limited to one record per call) to specified entity. The response will be the system generated ID.

Pull list of entities that API is allowed to work with

Returns the list of names and three flagged properties indicating whether it can be edited, updated, or viewed/queried.

Pull list of record(s) for a given entity

Pull list of records for a given entity with specific criteria, order by tag, group by tag and number of records. Note: There is no limit on number of records to be pulled but the user has to consider that larger results will be slower to process.

Pull metadata about all columns in specific entity

Lists columns, data types, and any restrictions or flags (NULL, Length, Primary Key, etc.) in a table.

Update record(s) for a specified entity

Update record(s) for a specified entity/area with specific criteria and a TriggerWorkflow as flag to run workflow after the update request succeeds or not. Maximum number of records that can be updated is 500 per call.

Create a new a record for a specified entity

Add a record (limited to one record per call) to specified entity. The response will be the system generated ID.

Parameters

Name Key Required Type Description
Entity Name
entityName True string

Table name name to add record to.

Name
Name string
Value
Value object

Returns

Pull list of entities that API is allowed to work with

Returns the list of names and three flagged properties indicating whether it can be edited, updated, or viewed/queried.

Returns

List of Entities

Pull list of record(s) for a given entity

Pull list of records for a given entity with specific criteria, order by tag, group by tag and number of records. Note: There is no limit on number of records to be pulled but the user has to consider that larger results will be slower to process.

Parameters

Name Key Required Type Description
Entity Name
entityName True string

Table name to query data from.

Attribute
Attribute string
Alias
Alias string
Clause
Clause string
Fields
Fields array of string
Direction
Direction string
GroupByTag
GroupByTag array of string
StartIndex
StartIndex integer

What index to start at, Default = 0

Length
Length integer

Row count starting from StartIndex, cannot excceed 1000, Default = 100

Returns

Pull metadata about all columns in specific entity

Lists columns, data types, and any restrictions or flags (NULL, Length, Primary Key, etc.) in a table.

Parameters

Name Key Required Type Description
Entity Name
entityName True string

Name of the Table to retrieve schema for.

Returns

List of columns, data types, and any restrictions or flags (NULL, Length, Primary Key, etc.) in a table

Update record(s) for a specified entity

Update record(s) for a specified entity/area with specific criteria and a TriggerWorkflow as flag to run workflow after the update request succeeds or not. Maximum number of records that can be updated is 500 per call.

Parameters

Name Key Required Type Description
Entity Name
entityName True string

Table name to update record(s) in.

Clause
Clause string
Name
Name string
Value
Value object
TriggerWorkflow
TriggerWorkflow boolean

Returns

Triggers

A scheduled trigger for created and updated records

A scheduled trigger that shows both created (new) records and any records which have been updated since a given amount of time.

A scheduled trigger that query created (new) records on a given interval

Query all newly created records by a date & time field compared to current date & time (greater than or equal to) on a specific interval.

A scheduled trigger that shows records updated since a specific datetime

Query all update records by a date & time field compared to current date & time (greater than or equal to) on a specific interval.

A scheduled trigger for created and updated records

A scheduled trigger that shows both created (new) records and any records which have been updated since a given amount of time.

Parameters

Name Key Required Type Description
Table Name
entityName True string

Table name to pull updated record(s) from.

Attribute
Attribute string
Alias
Alias string
Clause
Clause string
Fields
Fields array of string
Direction
Direction string
GroupByTag
GroupByTag array of string
StartIndex
StartIndex integer

What index to start at, Default = 0

Length
Length integer

Row count starting from StartIndex, cannot excceed 1000, Default = 100

Returns

response
object

A scheduled trigger that query created (new) records on a given interval

Query all newly created records by a date & time field compared to current date & time (greater than or equal to) on a specific interval.

Parameters

Name Key Required Type Description
Entity Name
entityName True string

Table name to pull new record(s) from.

Attribute
Attribute string
Alias
Alias string
Clause
Clause string
Fields
Fields array of string
Direction
Direction string
GroupByTag
GroupByTag array of string
StartIndex
StartIndex integer

What index to start at, Default = 0

Length
Length integer

Row count starting from StartIndex, cannot excceed 1000, Default = 100

Returns

response
object

A scheduled trigger that shows records updated since a specific datetime

Query all update records by a date & time field compared to current date & time (greater than or equal to) on a specific interval.

Parameters

Name Key Required Type Description
Entity Name
entityName True string

Table name to pull updated record(s) from.

Attribute
Attribute string
Alias
Alias string
Clause
Clause string
Fields
Fields array of string
Direction
Direction string
GroupByTag
GroupByTag array of string
StartIndex
StartIndex integer

What index to start at, Default = 0

Length
Length integer

Row count starting from StartIndex, cannot excceed 1000, Default = 100

Returns

response
object

Definitions

APIEntityListResponse

List of Entities

Name Path Type Description
Items
APIEntity

Define each entity

APIEntity

Define each entity

Name Path Type Description
EntityName
EntityName string

Entity name as it is in database

EntityNameDisplay
EntityNameDisplay string

Entity display name

AllowAdd
AllowAdd boolean

Indicates if allowed to add new record

AllowEdit
AllowEdit boolean

Indicates if allowed to edit record(S)

AllowView
AllowView boolean

Indicates if allowed to view record(s)

EntityNameForAPI
EntityNameForAPI string

Entity name that is used in CSS API

APISchemaResponse

List of columns, data types, and any restrictions or flags (NULL, Length, Primary Key, etc.) in a table

Name Path Type Description
Items
APISchema

APISchema

Name Path Type Description
Name
Name string
IsPrimaryKey
IsPrimaryKey boolean
IsIdentity
IsIdentity boolean
IsNullable
IsNullable boolean
DBType
DBType string
MaxLength
MaxLength integer
DataPrecision
DataPrecision integer
DataScale
DataScale integer
HasDefaultValue
HasDefaultValue boolean
IsComputedColumn
IsComputedColumn boolean
IsPassword
IsPassword boolean

APIAddRequestTuple

Name Path Type Description
Name
Name string
Value
Value object

APIUpdateResponse

Name Path Type Description
TotalAffected
TotalAffected integer
TotalFailed
TotalFailed integer
Message
Message string

APIAddRequest

Name Path Type Description
Tuples
Tuples array of APIAddRequestTuple

APIQueryResponse

Name Path Type Description
Items
object

object

This is the type 'object'.