NEW: Check our new hosted service COZYROC Cloud ...
Parature Connection
Note: Parature service has been discontinued. This page is kept for educational purposes. You can review the official Microsoft announcement here.
Overview
Configuration is provided for establishing connections with the Parature service. The configuration is used in the REST Connection Manager.
Setup
Press 
icon to get more information about the connection parameters.
Obtain data
Use REST Source component to get data from service resource.
Insert data
Use REST Destination component to insert data into service resource.
Configuration
Base URL address: https://[customerId].prod.parature.com/api/v1/[instanceId]/[departmentId].
-
The authentication uses a parameters-based authentication.
The authentication has the following user-defined parameters:
- Token:
The following request parameters will be automatically processed during the authentication process:
-
_token_:
{{=connection.user.Token}}
For further information, please check here.
Template Fields define custom and/or compound data types to enable flexible modelling of entities' fields.
- ShortText
Data type: DT_WSTR ( length 255 )
- LongText
Data type: DT_WSTR ( length 1000 )
- Entity
The gathered value is processed with
{{=(item[field.name] || {})[_.last(_.pairs(field.external[1]))[0]]}}expression. Field components:-
Uses template:
ShortText. - Contains the following components: @id, @uid, @href, Full_Name.
-
Uses template:
- EntityMultiple
Data type: DT_WSTR ( length 4000 ) A composite field. The gathered value is processed with
{{=(item[field.name] || {})[_.last(_.pairs(field.external[1]))[0]]}}expression.- AttachmentMultiple
Data type: DT_WSTR ( length 4000 ) A composite field. The gathered value is processed with
{{=item[field.name].Attachment}}expression.
Template Resources enable the reuse of fields and actions across multiple resources.
- [Read] action
-
Endpoint URL address:
/{{=resource.object}}.
The result is extracted from:{{=response.Entities[resource.object]}}.
The result is paginated.The following request parameters will be automatically processed:
-
_fields_:
{{=parameters.fields.join()}} -
_startPage_:
{{=parameters.iterator}} -
_pageSize_:
{{=parameters.batchSize}} -
_output_:
json -
_includeUserParameters:
{{=parameters}}
-
_fields_:
- [Create] action
-
Endpoint URL address:
/{{=resource.object}}.
The result is extracted from:{{=response[resource.object]}}.
The action uses POST method.The following request parameters will be automatically processed:
-
application/xml:
{{=json2xml(_.object([resource.object], [item]))}}
-
application/xml:
- [Update] action
-
Endpoint URL address:
/{{=resource.object}}/{{=item[resource.keyField]}}.
The result is extracted from:{{=response[resource.object]}}.
The action uses PUT method.The following request parameters will be automatically processed:
-
application/xml:
{{=json2xml(_.object([resource.object], [item]))}}
-
application/xml:
- [Delete] action
-
Endpoint URL address:
/{{=resource.object}}/{{=item[resource.keyField]}}.
The action uses DELETE method.The following request parameters will be automatically processed:
-
_purge_:
{{=parameters._purge_}}
-
_purge_:
- @id
A key field. Data type: DT_I4
- @uid
Template: ShortText. A read-only field.
- @href
Template: ShortText. A read-only field.
- @service-desk-uri
Template: ShortText. A read-only field.
- [External]
-
The external fields URL address:
/{{=resource.object}}/schema. The external fields list is extracted from:{{=_.pairs(response[resource.object])}}.- {{=external[0]}}
Template: {{? external[1]['@field-type'] == 'entity'}}{{='Entity'}}{{?? external[1]['@field-type'] == 'entitymultiple'}}{{='EntityMultiple'}}{{?? external[1]['@field-type'] == 'attachmentmultiple'}}{{='AttachmentMultiple'}}{{??}}{{=''}}{{?}}. Data type: {{=Parature.getDataType([external[1]['@data-type'])}} ( length {{=255}} ) The gathered value is processed with
{{=(item[field.name] || {})['#text']}}expression.
Resources represent entities exposed by the service. The API endpoints are grouped by resources.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/Article/Search.The action has the following user-defined parameters:
- search: Required. Specify search query (alias for "_keywords_").
The following request parameters will be automatically processed:
-
_keywords_:
{{=parameters.search}}
For further information check here.
- [Create] action
-
For further information check here.
- [Update] action
-
For further information check here.
- [Delete] action
-
For further information check here.
Based on resource template Base.
- [Read] action
-
For further information check here.
- [Create] action
-
For further information check here.
- [Update] action
-
For further information check here.
- [Delete] action
-
For further information check here.
- MimeType
Template: ShortText.
- Guid
Template: ShortText. Before setting, the value is processed with
{{=Parature.UploadFile('/Download/upload', item)}}expression.- Content
Data type: DT_IMAGE
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/Account/view.
The result is extracted from:{{=response.AccountView}}.For further information check here.
- [External]
-
The external fields URL address:
. The external fields list is extracted from:.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/Customer/view.
The result is extracted from:{{=response.CustomerView}}.For further information check here.
- [External]
-
The external fields URL address:
. The external fields list is extracted from:.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/Customer/status.
The result is extracted from:{{=response.Status}}.For further information check here.
- Description
Template: ShortText. The gathered value is processed with
{{=value['#text']}}expression.- Name
Template: ShortText. The gathered value is processed with
{{=value['#text']}}expression.- Text
Template: ShortText. The gathered value is processed with
{{=value['#text']}}expression.
- [External]
-
The external fields URL address:
. The external fields list is extracted from:.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/Customer/role.
The result is extracted from:{{=response.CustomerRole}}.For further information check here.
- Description
Template: ShortText. The gathered value is processed with
{{=value['#text']}}expression.- Name
Template: ShortText. The gathered value is processed with
{{=value['#text']}}expression.
- [External]
-
The external fields URL address:
. The external fields list is extracted from:.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/Asset/status.
The result is extracted from:{{=response.Status}}.For further information check here.
- Description
Template: ShortText. The gathered value is processed with
{{=value['#text']}}expression.- Name
Template: ShortText. The gathered value is processed with
{{=value['#text']}}expression.- Text
Template: ShortText. The gathered value is processed with
{{=value['#text']}}expression.
- [External]
-
The external fields URL address:
. The external fields list is extracted from:.
Based on resource template Base.
- [Read] action
-
The following request parameters will be automatically processed:
-
_fields_:
{{=_.without(parameters.fields, 'MimeType', 'Ticket_Attachments', 'Content').join()}}
For further information check here.
-
_fields_:
- [Create] action
-
For further information check here.
- [Update] action
-
For further information check here.
- [Delete] action
-
For further information check here.
- MimeType
Template: ShortText.
- Ticket_Attachments
Template: AttachmentMultiple. Before setting, the value is processed with
{{? value }}{{=value.Attachment.push(Parature.UploadFile('/Ticket/upload', item))}}{{??}}{{={'Attachment':[Parature.UploadFile('/Ticket/upload', item)]} }}{{?}}expression.- Content
Data type: DT_IMAGE
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/Ticket/view.
The result is extracted from:{{=response.TicketView}}.For further information check here.
- [External]
-
The external fields URL address:
. The external fields list is extracted from:.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/Ticket/status.
The result is extracted from:{{=response.Status}}.For further information check here.
- Customer_Text
Template: ShortText. The gathered value is processed with
{{=value['#text']}}expression.- Name
Template: ShortText. The gathered value is processed with
{{=value['#text']}}expression.
- [External]
-
The external fields URL address:
. The external fields list is extracted from:.
Based on resource template Base.
- [Read] action
-
For further information check here.
Based on resource template Base.
- [Read] action
-
For further information check here.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/Chat/{{=parameters.chat}}/Transcript.
The result is extracted from:{{=response.Transcript}}.The action has the following user-defined parameters:
- chat: Required. Specify chat identifier.
For further information check here.
- [External]
-
The external fields URL address:
. The external fields list is extracted from:.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/Csr/role.
The result is extracted from:{{=response.CsrRole}}.For further information check here.
- Description
Template: ShortText. The gathered value is processed with
{{=value['#text']}}expression.- Name
Template: ShortText. The gathered value is processed with
{{=value['#text']}}expression.
- [External]
-
The external fields URL address:
. The external fields list is extracted from:.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/Csr/status.
The result is extracted from:{{=response.Status}}.For further information check here.
- Description
Template: ShortText. The gathered value is processed with
{{=value['#text']}}expression.- Name
Template: ShortText. The gathered value is processed with
{{=value['#text']}}expression.
- [External]
-
The external fields URL address:
. The external fields list is extracted from:.
Based on resource template Base.
- [Read] action
-
For further information check here.
- Abbreviation
Template: ShortText. The gathered value is processed with
{{=value['#text']}}expression.- Timezone
Template: ShortText. The gathered value is processed with
{{=value['#text']}}expression.
- [External]
-
The external fields URL address:
. The external fields list is extracted from:.
What's New
1.7
- New: Introduced connection.
Related documentation
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.