Automate Confluence page creation from Jira work items in JSM Cloud

Summary

This article outlines how to use an automation rule to automatically create a page in Confluence when a work item is created in Jira.

Example use case:

There are departments that require the employee to create a Confluence page after raising a ticket in Jira to further track detailed information about their request.

Solution

Display Jira work item information in Confluence

1. The employee will raise a ticket to propose a work trip with brief information.

2. Automation will automatically create a page.

3. The employee is expected to have a Confluence license to update the page with detailed information.

4. Finance will review the ticket and transition the work item for approval from the Manager.

5. The manager will review the Confluence page and approve it.

Step 1: Create a Jira Service Management project

1. Go to the Jira site.

2. At the top bar, click Projects > Create Project.

3. Choose the General service management for business teams project template.

4. Create the project, and name it Work Trip Planning.

Step 2: Create a few custom fields for employees to fill up when creating the ticket.

1. Go to Jira Settings > Work Items > Custom fields.

2. Click Create Custom Fields.

3. Choose Date Picker custom field type.

4. Name it Travel Date and click Create.

5. In the search panel, key in the project key. Then, look for a screen with Jira Service Management: General Request Work Item Screen name.

6. Tick it and click Update.

7. Repeat the step 2 to 6 for the field below:

   1. Trip Location - Use the "Short Text" custom field type.

   2. Flight Date - Use the "Date Picker" custom field type.

   3. Flight Time - Use the "Short Text" custom field type.

Step 3: Create a new request type and update the form with the custom fields.

1. Go to the new project you've created.

2. Go to Project Settings > Request Types.

3. Click Create Request Type.

4. Key in Work Trip Proposal and choose to Submit a request or incident work item type.

5. Tick the General and click Create.

6. Open the newly created request type to edit the form.

7. Drag all the new custom fields created previously from the right sidebar to the form. Including the Approvers field.

8. Update the Description portal field name with "What is the purpose of this trip?".

Step 4: Create the automation to automatically create a page once the ticket created

1. The automation will look as below:

   

2. Create a file automation-rule-create-page.json using the following code

   {"cloud":true,"rules":[{"id":9686161,"clientKey":"04e788b4-1a04-359a-adae-1e77100085fa","name":"Test create work trip confluence page","state":"ENABLED","description":"","authorAccountId":"557057:1a8aeee5-40e9-413a-9f4e-2f074f09644a","actor":{"type":"ACCOUNT_ID","value":"557058:f58131cb-b67d-43c7-b30d-6b58d40bd077"},"created":1672363669174,"updated":1672962349570,"trigger":{"id":"201052509","component":"TRIGGER","parentId":null,"conditionParentId":null,"schemaVersion":1,"type":"jira.issue.event.trigger:created","value":{"eventKey":"jira:issue_created","issueEvent":"issue_created"},"children":[],"conditions":[],"connectionId":null},"components":[{"id":"201052510","component":"CONDITION","parentId":null,"conditionParentId":null,"schemaVersion":3,"type":"jira.issue.condition","value":{"selectedField":{"type":"NAME","value":"Request Type"},"selectedFieldType":"com.atlassian.servicedesk:vp-origin","comparison":"EQUALS","compareValue":{"type":"NAME","modifier":null,"value":"Work Trip Proposal","multiValue":false,"source":null}},"children":[],"conditions":[],"connectionId":null},{"id":"201052511","component":"ACTION","parentId":null,"conditionParentId":null,"schemaVersion":1,"type":"jira.issue.outgoing.webhook","value":{"url":"https://gohappyalways.atlassian.net/wiki/rest/api/content","headers":[{"id":"_header_1672363488172","name":"Authorization","value":"**************************","headerSecure":true}],"sendIssue":false,"contentType":"custom","customBody":"{\n \"type\": \"page\",\n \"title\": \"{{issue.summary}}\",\n \"space\": {\n \"key\": \"TP\"\n },\n \"body\": {\n \"editor\": {\n \"value\": \"{\\\"type\\\":\\\"doc\\\",\\\"content\\\":[{\\\"type\\\":\\\"table\\\",\\\"attrs\\\":{\\\"layout\\\":\\\"default\\\",\\\"localId\\\":\\\"8c95df3e-bc5c-43f6-a1fb-b00c8d74ae88\\\",\\\"isNumberColumnEnabled\\\":false,\\\"__autoSize\\\":false},\\\"content\\\":[{\\\"type\\\":\\\"tableRow\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableHeader\\\",\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[271],\\\"background\\\":null},\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}],\\\"text\\\":\\\"Requestor\\\"}]}]},{\\\"type\\\":\\\"tableCell\\\",\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[487],\\\"background\\\":null},\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"mention\\\",\\\"attrs\\\":{\\\"id\\\":\\\"{{issue.reporter.accountId}}\\\",\\\"text\\\":\\\"\\\",\\\"accessLevel\\\":\\\"CONTAINER\\\",\\\"userType\\\":null}},{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\" \\\"}]}]}]},{\\\"type\\\":\\\"tableRow\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableHeader\\\",\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[271],\\\"background\\\":null},\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}],\\\"text\\\":\\\"Jira ticket\\\"}]}]},{\\\"type\\\":\\\"tableCell\\\",\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[487],\\\"background\\\":null},\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"inlineCard\\\",\\\"attrs\\\":{\\\"url\\\":\\\"{{issue.url}}\\\",\\\"data\\\":null}},{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\" \\\"}]}]}]}]},{\\\"type\\\":\\\"heading\\\",\\\"content\\\":[{\\\"type\\\":\\\"emoji\\\",\\\"attrs\\\":{\\\"id\\\":\\\"1f4bc\\\",\\\"text\\\":\\\"💼\\\",\\\"shortName\\\":\\\":briefcase:\\\"}},{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\" Work trip name\\\"}],\\\"attrs\\\":{\\\"level\\\":2}},{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"{{issue.summary}}\\\"}]},{\\\"type\\\":\\\"heading\\\",\\\"content\\\":[{\\\"type\\\":\\\"emoji\\\",\\\"attrs\\\":{\\\"id\\\":\\\"1f3af\\\",\\\"text\\\":\\\"🎯\\\",\\\"shortName\\\":\\\":dart:\\\"}},{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\" Trip purpose\\\"}],\\\"attrs\\\":{\\\"level\\\":2}},{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"{{issue.description}}\\\"}]},{\\\"type\\\":\\\"table\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableRow\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Dates\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"background\\\":\\\"#f4f5f7\\\",\\\"rowspan\\\":1,\\\"colwidth\\\":[340]}},{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Location(s)\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"background\\\":\\\"#f4f5f7\\\",\\\"rowspan\\\":1,\\\"colwidth\\\":[340]}}]},{\\\"type\\\":\\\"tableRow\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"{{issue.Flight Date}}\\\"},{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\" \\\"}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[340],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"{{issue.Trip Location}}\\\"}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[340],\\\"background\\\":null}}]},{\\\"type\\\":\\\"tableRow\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[340],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[340],\\\"background\\\":null}}]}],\\\"attrs\\\":{\\\"layout\\\":\\\"default\\\",\\\"localId\\\":\\\"94884945-e453-4c20-8ed1-079e839fad33\\\",\\\"isNumberColumnEnabled\\\":false,\\\"__autoSize\\\":false}},{\\\"type\\\":\\\"heading\\\",\\\"content\\\":[{\\\"type\\\":\\\"emoji\\\",\\\"attrs\\\":{\\\"id\\\":\\\"FE0F\\\",\\\"text\\\":\\\"✈️\\\",\\\"shortName\\\":\\\":airplane:\\\"}},{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\" Departing flight\\\"}],\\\"attrs\\\":{\\\"level\\\":3}},{\\\"type\\\":\\\"table\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableRow\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Date\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"background\\\":\\\"#deebff\\\",\\\"rowspan\\\":1,\\\"colwidth\\\":[170]}},{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Departure time\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"background\\\":\\\"#deebff\\\",\\\"rowspan\\\":1,\\\"colwidth\\\":[170]}},{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Airline\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"background\\\":\\\"#deebff\\\",\\\"rowspan\\\":1,\\\"colwidth\\\":[170]}},{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Confirmation code\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"background\\\":\\\"#deebff\\\",\\\"rowspan\\\":1,\\\"colwidth\\\":[170]}}]},{\\\"type\\\":\\\"tableRow\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"{{issue.Flight Date}}\\\"},{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\" \\\"}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"{{issue.Flight Time}}\\\"}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}}]}],\\\"attrs\\\":{\\\"layout\\\":\\\"default\\\",\\\"localId\\\":\\\"30574d23-1e2c-4509-8def-b4fc7a092508\\\",\\\"isNumberColumnEnabled\\\":false,\\\"__autoSize\\\":false}},{\\\"type\\\":\\\"heading\\\",\\\"content\\\":[{\\\"type\\\":\\\"emoji\\\",\\\"attrs\\\":{\\\"id\\\":\\\"1f697\\\",\\\"text\\\":\\\"🚗\\\",\\\"shortName\\\":\\\":red_car:\\\"}},{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\" Car rental\\\"}],\\\"attrs\\\":{\\\"level\\\":3}},{\\\"type\\\":\\\"table\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableRow\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Company\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"background\\\":\\\"#ffebe6\\\",\\\"rowspan\\\":1,\\\"colwidth\\\":[170]}},{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Pickup time\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"background\\\":\\\"#ffebe6\\\",\\\"rowspan\\\":1,\\\"colwidth\\\":[170]}},{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Pickup/drop off location\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"background\\\":\\\"#ffebe6\\\",\\\"rowspan\\\":1,\\\"colwidth\\\":[170]}},{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Drop off time\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"background\\\":\\\"#ffebe6\\\",\\\"rowspan\\\":1,\\\"colwidth\\\":[170]}}]},{\\\"type\\\":\\\"tableRow\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}}]}],\\\"attrs\\\":{\\\"layout\\\":\\\"default\\\",\\\"localId\\\":\\\"c088a4b3-4b62-43d3-b25d-ad3a876f38cb\\\",\\\"isNumberColumnEnabled\\\":false,\\\"__autoSize\\\":false}},{\\\"type\\\":\\\"heading\\\",\\\"content\\\":[{\\\"type\\\":\\\"emoji\\\",\\\"attrs\\\":{\\\"id\\\":\\\"1f3e8\\\",\\\"text\\\":\\\"🏨\\\",\\\"shortName\\\":\\\":hotel:\\\"}},{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\" Hotel\\\"}],\\\"attrs\\\":{\\\"level\\\":3}},{\\\"type\\\":\\\"table\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableRow\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Hotel name\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"background\\\":\\\"#fffae6\\\",\\\"rowspan\\\":1,\\\"colwidth\\\":[136]}},{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Hotel address\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"background\\\":\\\"#fffae6\\\",\\\"rowspan\\\":1,\\\"colwidth\\\":[136]}},{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Confirmation code\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"background\\\":\\\"#fffae6\\\",\\\"rowspan\\\":1,\\\"colwidth\\\":[136]}},{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Check in\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"background\\\":\\\"#fffae6\\\",\\\"rowspan\\\":1,\\\"colwidth\\\":[136]}},{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Check out\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"background\\\":\\\"#fffae6\\\",\\\"rowspan\\\":1,\\\"colwidth\\\":[136]}}]},{\\\"type\\\":\\\"tableRow\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[136],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[136],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[136],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[136],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[136],\\\"background\\\":null}}]},{\\\"type\\\":\\\"tableRow\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[136],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[136],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[136],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[136],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[136],\\\"background\\\":null}}]}],\\\"attrs\\\":{\\\"layout\\\":\\\"default\\\",\\\"localId\\\":\\\"b053c84c-3bb0-4b6a-bce1-5f3c54bd2c4d\\\",\\\"isNumberColumnEnabled\\\":false,\\\"__autoSize\\\":false}},{\\\"type\\\":\\\"heading\\\",\\\"content\\\":[{\\\"type\\\":\\\"emoji\\\",\\\"attrs\\\":{\\\"id\\\":\\\"1f5d3\\\",\\\"text\\\":\\\"🗓\\\",\\\"shortName\\\":\\\":calendar_spiral:\\\"}},{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\" Activities\\\"}],\\\"attrs\\\":{\\\"level\\\":3}},{\\\"type\\\":\\\"table\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableRow\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Date\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"background\\\":\\\"#f4f5f7\\\",\\\"rowspan\\\":1,\\\"colwidth\\\":[170]}},{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Location name & address\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"background\\\":\\\"#f4f5f7\\\",\\\"rowspan\\\":1,\\\"colwidth\\\":[170]}},{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Activity\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"background\\\":\\\"#f4f5f7\\\",\\\"rowspan\\\":1,\\\"colwidth\\\":[170]}},{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Comments\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"background\\\":\\\"#f4f5f7\\\",\\\"rowspan\\\":1,\\\"colwidth\\\":[170]}}]},{\\\"type\\\":\\\"tableRow\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"placeholder\\\",\\\"attrs\\\":{\\\"text\\\":\\\"Type /date to add\\\"}}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}}]},{\\\"type\\\":\\\"tableRow\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}}]},{\\\"type\\\":\\\"tableRow\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}}]}],\\\"attrs\\\":{\\\"layout\\\":\\\"default\\\",\\\"localId\\\":\\\"ba2ed566-cf02-4340-827d-aa689afc0cd4\\\",\\\"isNumberColumnEnabled\\\":false,\\\"__autoSize\\\":false}},{\\\"type\\\":\\\"heading\\\",\\\"content\\\":[{\\\"type\\\":\\\"emoji\\\",\\\"attrs\\\":{\\\"id\\\":\\\"1f37d\\\",\\\"text\\\":\\\"🍽\\\",\\\"shortName\\\":\\\":fork_knife_plate:\\\"}},{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\" Restaurants\\\"}],\\\"attrs\\\":{\\\"level\\\":3}},{\\\"type\\\":\\\"table\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableRow\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Restaurant name\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Restaurant address\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Reservation time\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Comments\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}}]},{\\\"type\\\":\\\"tableRow\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}}]},{\\\"type\\\":\\\"tableRow\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}}]}],\\\"attrs\\\":{\\\"layout\\\":\\\"default\\\",\\\"localId\\\":\\\"e4255766-a442-4bdf-9eea-3ab9df0a32c3\\\",\\\"isNumberColumnEnabled\\\":false,\\\"__autoSize\\\":false}},{\\\"type\\\":\\\"heading\\\",\\\"content\\\":[{\\\"type\\\":\\\"emoji\\\",\\\"attrs\\\":{\\\"id\\\":\\\"1f6ec\\\",\\\"text\\\":\\\"🛬\\\",\\\"shortName\\\":\\\":airplane_arriving:\\\"}},{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\" Return flight\\\"}],\\\"attrs\\\":{\\\"level\\\":3}},{\\\"type\\\":\\\"table\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableRow\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Date\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"background\\\":\\\"#deebff\\\",\\\"rowspan\\\":1,\\\"colwidth\\\":[170]}},{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Departure time\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"background\\\":\\\"#deebff\\\",\\\"rowspan\\\":1,\\\"colwidth\\\":[170]}},{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Airline\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"background\\\":\\\"#deebff\\\",\\\"rowspan\\\":1,\\\"colwidth\\\":[170]}},{\\\"type\\\":\\\"tableHeader\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"text\\\",\\\"text\\\":\\\"Confirmation code\\\",\\\"marks\\\":[{\\\"type\\\":\\\"strong\\\"}]}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"background\\\":\\\"#deebff\\\",\\\"rowspan\\\":1,\\\"colwidth\\\":[170]}}]},{\\\"type\\\":\\\"tableRow\\\",\\\"content\\\":[{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\",\\\"content\\\":[{\\\"type\\\":\\\"placeholder\\\",\\\"attrs\\\":{\\\"text\\\":\\\"Type /date to add\\\"}}]}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}},{\\\"type\\\":\\\"tableCell\\\",\\\"content\\\":[{\\\"type\\\":\\\"paragraph\\\"}],\\\"attrs\\\":{\\\"colspan\\\":1,\\\"rowspan\\\":1,\\\"colwidth\\\":[170],\\\"background\\\":null}}]}],\\\"attrs\\\":{\\\"layout\\\":\\\"default\\\",\\\"localId\\\":\\\"4511548d-12ea-4a85-8795-dc074e9dcb61\\\",\\\"isNumberColumnEnabled\\\":false,\\\"__autoSize\\\":false}}]}\",\n \"representation\": \"atlas_doc_format\"\n }\n }\n}","method":"POST","responseEnabled":true,"continueOnErrorEnabled":false},"children":[],"conditions":[],"connectionId":null},{"id":"201052512","component":"ACTION","parentId":null,"conditionParentId":null,"schemaVersion":1,"type":"codebarrel.action.log","value":"confluence link : {{webResponse.body._links.webui}}","children":[],"conditions":[],"connectionId":null},{"id":"201052513","component":"ACTION","parentId":null,"conditionParentId":null,"schemaVersion":1,"type":"jira.issue.comment","value":{"comment":"Hi {{issue.Reporter.displayName}} , thank you for the proposal. Please transition work item to \"In Progress\" and update the confluence page linked with the full details. Once done , transition the work item to \"In Review\".\n\nConfluence page : {{baseUrl}}/wiki{{webResponse.body._links.webui}}\n\n","publicComment":true,"commentVisibility":null,"sendNotifications":true,"addCommentOnce":true},"children":[],"conditions":[],"connectionId":null}],"canOtherRuleTrigger":false,"notifyOnError":"FIRSTERROR","projects":[{"projectId":"10052","projectTypeKey":"service_desk"}],"labels":[],"tags":[{"id":20656436,"tagType":"IS_RULE_UPDATED","tagValue":"true"}],"ruleScope":{"resources":["ari:cloud:jira:5f6ba0b1-7152-41cb-aaf3-1015a7182d64:project/10052"]},"writeAccessType":"UNRESTRICTED","collaborators":[]}]}

3. Go to the site's global automation page, which is https://xxxx.atlassian.net/jira/settings/automation

4. Click the three dots on the top right corner and click Import Rule.

5. Click Upload JSON and choose the file.

6. Under "Restrict to projects", choose the newly created project.

7. Tick it and click Next > Let's do this.

8. Go back to the project and go to Project Settings > Automation.

9. Open the newly uploaded automation.

10. Click the Then : Send Web Request . The REST API used for this request are the Create Content API from Confluence Cloud , which is POST /wiki/rest/api/content

11. Update the section as per screenshot below:

    

12. For the Header section, add as below:

    1. Header Name: Authorization.

    2. Header Value: Basic XXXXX.

       1. The XXXX value are a decoded Base64 value of username:API Token.

       2. Follow the steps in Manage API tokens for your Atlassian account documentation to create an API Token for your Atlassian Account.

       3. Then, follow the instructions here to encode your useremail:APItoken to base64.

       4. Paste it to the Header Value.

13. For the space key, you can use the space created for the project.

    1. Go to Project Settings > Knowledge Base.

    2. Hover to click the space name.

    3. From the URL, you will notice the space key from "/wiki/spaces/XXX/overview" . The XXX are the space key.

14. Once done updating the automation, Save it and enable the automation.

Step 5: Allowing the user with Confluence user to edit the page.

1. Go to the space permission setting.

2. Add the groups that needed permission.

3. Detail steps can, refer to Assign space permissions documentation.

Step 6: Configure the Approval configuration

1. Go to Project Settings > Workflow.

2. Click the pencil icon for the Default ESM workflow for Jira Service Management workflow to edit it.

3. In the Diagram view, click Pending status.

4. Tick the Include approval step and click Edit.

5. Additionally, if you would like to allow the employee to transition the work item to Pending status, you can click the transition and tick the Show transition in the customer portal.

6. Once done, publish the workflow.

7. For a detailed explanation about Approval and displaying transition in the workflow, may refer to the documentation.

   • Set up an approval stage

   • Show a workflow transition in the portal

Step 7: Allowing employee or customer to choose another account as an approver

1. Go to Project Settings > Customer Permission.

2. Under "Customer Sharing", choose the Customers can search for other customers within their project or organizations.

3. For detailed explanation about this, you may refer to this documentation: Change project customer permissions

Step 8: It's time to test

1. Go to customer portal.

2. Choose Work Trip Proposal.

3. Raise a ticket.

4. A ticket will be created, and a comment will be added with the Confluence page link.

5. If the user has access to the space, they can access the link and edit it.

6. Assigned the ticket and transitioned it to "Pending". The approver will notice the Approve/Decline button as below.

7. The approval has been approved it and the comment will be updated with the approval status.

8. The ticket can be closed if needed.