SDP To Zoho Project Integration

SDP To Zoho Project Integration

Requirement:
When a change is moved to "Implementation" Stage, a project in Zoho Project has to be created.  

Generating an Auth token
To use the 'Project API' we will need Project's authentication token from Zoho Accounts.
Follow the instructions in the below URL to generate an auth token: https://www.zoho.com/projects/help/rest-api/get-tickets-api.html
Ensure that you update the zohoProject.json file with your instance-specific access_token, refresh_token, client_secret, client_id, and redirect_url details and move the file to <SDP_Home>/integration/custom_scripts folder.

Sample zohoProject.json file content as follows

  1. {
  2.     "access_token": "1000.xxxxxxx396554369275a3db92679fa.8c5fd7092ae31eb2358feeab8b8e602f",
  3.     "refresh_token": "1000.d8xxxxxxxx047c3c3da8610191d3.f21a32a36331c29519ffd5a9985cc94e",
  4.     "code": "1000.4664c4xxxxxxxxxxcc65299a5.a82994facd91628f9929f5865832ffd8",
  5.     "client_secret": "e7c2c896xxxxxxxxxxd4c56c0c1e7b38af0",
  6.     "client_id": "1000.QSKYME9xxxxxxxxxxxxNUSSG4DO94O",
  7.     "redirect_url": "https://abc.com"
  8. }



These details will be used to regenerate the access token if it expires.

In the attached script utilizes the change title and change description content for creating the project.  These can also be modified as per your requirement.

Adding a Custom Field In Projects:
We can add a custom field in projects to hold the SDP - Change ID.
  1. Login to Zoho Projects > Goto Setup > Customization > Layouts and Fields > Projects > You can create a new layout or edit the standard layout itself.
    1. We've integrated the custom field directly into the standard layout
    2. Add a custom section and name it SDP Details
    3. Include a single line field to hold the ChangeID 

    4. Save the change and Navigate to create new projects page.
    5. On the new projects page, you have two options: either inspect the page to retrieve the ID of the newly created element or use the GET Custom Field API to access column name details. For more information, refer to: https://www.zoho.com/projects/help/rest-api/projects-api.html#alink3

Steps to follow:
  1. Download the attached scripts. 
  2. Update the portalID and Custom Field name in OP_ZohoProjectIntegration.py as per your instance.  We can get the portalid by invoking Get All Portals API.  Refer: https://www.zoho.com/projects/help/rest-api/portals-api.html#alink1
  3. Move the python script to <SDP_Home>/integration/custom_scripts and ZohoProjectIntegration.txt to <SDP_Home>/integration/custom_scripts/executor_files
  4. Configure a change custom trigger to be automatically invoked whenever they are moved to the integration stage.




The provided script encompasses this scenario as well: When transitioning a change to the "Implementation" Stage, a task must be generated in Zoho Project.
Modify the projectID and utilize the createTaskInProject() function instead of createProject().  Uncomment and update line 12 with the project ID. Uncomment lines 110, 115, 123, and comment out lines 109, 114, 122.

                    New to ADSelfService Plus?

                      • Related Articles

                      • Zoho Project to SDP Integration

                        Requirement: Considering the earlier integration discussed in the article: https://pitstop.manageengine.com/portal/en/kb/articles/sdp-to-zoho-project-integration Subsequently, upon adding a task to Zoho Projects, it's essential to mirror this action ...
                      • Azure DevOps Integration

                        Feature:  Azure DevOps Integration <-->  ServiceDeskPlus (Plugin Model) --> Create a new work-item in Azure DevOps when a request is created in SDP --> Update SDP request status when a Azure DevOps work-item status is updated --> Updating Comments ...
                      • ZOHO assist integration FAQ's

                        1) ZOHO Assist not working or unable to send emails or exception throws while initiating the session - Users who purchased ZOHO Assist needs to sign up to the https://assist.zoho.com/ with the registered user Email to make the integration work. - ...
                      • Integrating Zoho Projects with SDP MSP change management

                        PURPOSE: When a change is created or edited as required, a project is created in Zoho Projects respectively. Here is an example of creating a project in Zoho Projects when a change is created under a specific site in SDP MSP. TESTED IN MSP BUILDS: ...
                      • ZOHO CRM Integration with SDP MSP

                        Account's Sync : If MSP SDP has exact Account Name as that of CRM's Account Name , then CRM data will be overwritten in MSP SDP. (Note : Address details will be overwritten in MSP SDP). New Account from CRM (which is not in MSP SDP) will be added to ...