Copy data from Sharepoint to Cascading custom field

Evert Morren Atlas Admin

In Sharepoint I have a list with Countries and per country the actual project numbers. In Jira I have a custom cascading field country (parent) and project (child). How can I copy the data from Sharepoint to the Jira field on a daily sheduled base. I am looking for an API but can't found it.

Jason U

Hi Evert,

There’s no direct REST API dedicated to cascading field synchronization, but you can achieve this using the standard Jira Cloud REST API and a scheduled integration script or Power Automate flow from SharePoint.

Here’s how you can set it up:

1. Use the Jira REST API to update cascading fields
   Endpoint:

   PUT /rest/api/3/issue/{issueIdOrKey}

   Example payload for a cascading field (replace customfield_12345 with your actual field ID):

   { "fields": { "customfield_12345": { "value": "CountryName", "child": { "value": "ProjectName" } } } }

   You can find your field ID by visiting:
   Jira Settings → Issues → Custom fields → ... → View field details

2. Automate the data transfer from SharePoint

   • In Power Automate, create a daily scheduled flow.

   • Use the SharePoint “Get items” action to fetch your list data.

   • Then call the Jira REST API with an HTTP action, mapping “Country” and “Project” from SharePoint to the corresponding cascading field values.

3. Authentication
   Use Basic Auth with API token (or OAuth 2.0 if managed centrally).

   Authorization: Basic base64(email:APIToken)

 

• Jira Cloud REST API – Edit Issue

• Microsoft Power Automate + Jira integration docs

If you’re managing multiple fields or large datasets, a middleware like Zapier, Make (Integromat), or n8n can make this process easier to maintain.