Zendesk to Sharepoint by COZYROC

In this integration, the Microsoft Graph connection acts as the bridge, providing an efficient and automated process for transferring Zendesk object data to the desired Sharepoint location. This integration streamlines the flow of information, ensuring that data from Zendesk is seamlessly and securely transferred to Sharepoint, fostering collaboration and accessibility within your organization.

Setup Guide

This integration will establish a connection between Zendesk and Sharepoint. Once the connection is established, the integration will then pull the data from each Zendesk object specified in the Object List parameter. The integration will then generate a CSV file for each object and send all files to the desired Sharepoint location. If the parameter Compression is set to true, all CSV files will be compressed and uploaded to the desired Sharepoint location. The uploaded files will be named as Object_currentdate.

To run this integration and connect Zendesk to Sharepoint, you need to configure the parameters that are mentioned below.

Zendesk

• Server Host Required. Provide the relevant [domain] in the Server URL.
• Token File Required. Select the Zendesk Rest Token file from the drop-down list. Review the KB-Article mentioned here on how to generate the token file.
• Object List Required. This parameter accepts comma-separated values if you want to pull data from multiple objects, e.g. Ticket, Organization, etc.
• Batch Size Required. The default is set to 100.
• Query Parameter Optional. Multiple query parameters are separated by a new line.
• Compression Optional. The default is set to True.

Microsoft Graph

• Server Host Required. The default is set to https://graph.microsoft.com/v1.0/sites/root when connecting to the default SharePoint instance. Set server host URL to https://graph.microsoft.com/v1.0/sites/<site-id> when connecting to a specific SharePoint instance.
• Token File Required. Select the Rest Token file from the drop-down list. Review the KB-Article mentioned here regarding how to generate the token file.
• Destination Folder Required. Specify the path to the destination folder ending with a trailing slash.

Current Available Zendesk Objects that can be used to pull data from.

Activity App App Installation App Installation Location App Location Audit Log Authorized Global Client Automation Bookmark Brand Custom Agent Role Dynamic Content Item Group Group Membership Job Status Locale Macro Macro Action OAuth Client OAuth Token Organization Organization Field Organization Membership Organization Subscription Request Resource Collection Satisfaction Rating Satisfaction Reason Schedule Session Sharing Agreement SLA Policy Support Address Suspended Ticket Tag Target Ticket Ticket Form Ticket Metric Ticket Metric Event (Required Query Parameter -> start_time) Ticket Skip Trigger Twitter Channel User User Field View