Video tutorial

Watch this quick video to see the integration in action. It walks you through the end-to-end setup, including:

Installing the SSIS PowerPack
Configuring a secure connection to ManageEngine ServiceDesk Plus (Zoho)
Working with ManageEngine ServiceDesk Plus (Zoho) data directly inside SSIS
Exploring advanced API Source features

While this video uses the OData Connector as an example, the core concepts and setup process are exactly the same for the ManageEngine ServiceDesk Plus (Zoho) Connector.

Ready to dive in? Download the product to jump right in, or follow the step-by-step guide below to see how it works.

Prerequisites

Before we begin, make sure the following prerequisites are met:

SQL Server Data Tools (SSDT) designer installed for Visual Studio.
SQL Server Integration Services Projects 2022+ Visual Studio extension installed.
SSIS PowerPack is installed.

Delete request in SSIS

Open Visual Studio and click Create a new project.
Select Integration Services Project. Enter a name and location for your project, then click OK.
From the SSIS Toolbox, drag and drop a Data Flow Task onto the Control Flow surface, and double-click it:
Make sure you are in the Data Flow Task designer:
Read the data from the source, using any desired source component. You can even make an API call using the ZappySys JSON/XML/API Source and read data from there. In this example, we will use an OLE DB Source component to read real-time data from a SQL Server database.
From the SSIS Toolbox drag and drop API Destination (Predefined Templates) on the Data Flow Designer surface and connect source component with it, and double click to edit it.
Select New Connection to create a new connection:

API Destination - ManageEngine ServiceDesk Plus (Zoho)

Read and write ServiceDesk Plus (Zoho) data effortlessly. Integrate, manage, and automate requests, tasks, comments, and worklogs — almost no coding required.
To configure the ManageEngine ServiceDesk Plus (Zoho) connector, choose one of the following methods:
- Choose from Popular Connector List: Select a pre-installed service directly from the dropdown menu.
- Search Online: Use this to find and download a new connector file to your computer.
- Use Saved/Downloaded File: Once the file is downloaded, browse your local drive to load it into the configuration.
After that, just click Continue >>:

ManageEngine ServiceDesk Plus (Zoho)

Proceed with selecting the desired Authentication Type. Then select API Base URL (in most cases default one is the right one). Finally, fill in all the required parameters and set optional parameters if needed. You may press a link Steps to Configure which will help set certain parameters. More info is available in Authentication section.

OAuth

ManageEngine ServiceDesk Plus (Zoho) authentication

OAuth Connection for ManageEngine ServiceDesk Plus API [API reference]

To register custom App, perform the following steps (Detailed steps found in the help link at the end)

Go to Zoho API Console
Click Add Client link
Select Server-based Applications option
Enter desired client name (Display purpose only)
Enter some URL for Company homepage
For Authorized Redirect URI enter https://zappysys.com/oauth (Or enter your own but we recommend using ZappySys one if possible). This URL must match on Zoho Connector UI.
Click CREATE.
Copy Client ID and Secret and paste on Zoho Connector UI.

API Connection Manager configuration

Just perform these simple steps to finish authentication configuration:

Set Authentication Type to OAuth [OAuth]
Optional step. Modify API Base URL if needed (in most cases default will work).
Fill in all the required parameters and set optional parameters if needed.
Press Generate Token button to generate the tokens.
Finally, hit OK button:

ManageEngine ServiceDesk Plus (Zoho)

OAuth [OAuth]

https://sdpondemand.manageengine.com/api/v3

Optional Parameters
ClientId
ClientSecret
Permissions	SDPOnDemand.requests.ALL
AccountUrl	https://accounts.zoho.com
RedirectUrl	https://zappysys.com/oauth
RetryMode	RetryWhenStatusCodeMatch
RetryStatusCodeList	429
RetryCountMax	5
RetryMultiplyWaitTime	True

Find full details in the ManageEngine ServiceDesk Plus (Zoho) Connector authentication reference.

Select Requests table from the dropdown, then select Delete as operation, and hit Preview Data:

API Destination - ManageEngine ServiceDesk Plus (Zoho)

Read and write ServiceDesk Plus (Zoho) data effortlessly. Integrate, manage, and automate requests, tasks, comments, and worklogs — almost no coding required.

ManageEngine ServiceDesk Plus (Zoho)

Requests

Delete

Required Parameters
RequestId	Fill-in the parameter...
Optional Parameters
MetaDetectionOrder	Default
ContineOn404Error	True

SSIS API Destination - Access table operation

Finally, map the desired columns:

API Destination - ManageEngine ServiceDesk Plus (Zoho)

Read and write ServiceDesk Plus (Zoho) data effortlessly. Integrate, manage, and automate requests, tasks, comments, and worklogs — almost no coding required.
That's it; we successfully configured the POST API Call. In a few clicks we configured the ManageEngine ServiceDesk Plus (Zoho) API call using ZappySys ManageEngine ServiceDesk Plus (Zoho) Connector

ManageEngine ServiceDesk Plus (Zoho) Connector actions

Need another use case? Pick the next ManageEngine ServiceDesk Plus (Zoho) action in SSIS below.

Conclusion

You now know how to delete request in SSIS without writing complex code. SSIS ManageEngine ServiceDesk Plus (Zoho) Connector handled pagination and authentication automatically.

Ready to get started? Download the trial or ping us via chat if you need help:

Download SSIS PowerPack

Chat with an Expert

ManageEngine ServiceDesk Plus (Zoho) Connector for SSIS : Delete request