How to Get Description field Data as JSON format

Jira Development Jira Cloud
,
1

Hey Team,
I have a description field as JSON data and I want to use the description field on Automation for Jira then I want to create multiple sub-tasks from JSON data.
I created an A4J rule but I can not fetch the data as json from webResponse.

How can I solve this? Is there any idea?

2

Hi @MuhammetAyal , welcome to the developer community!

Can you please clarify how you have built your automation, and where the JSON data is coming from? For example, are you using the Incoming Webhook trigger, or Send Web Request action?

Regards,
Michael

3

Thanks for your back @mventnor.

I am using Get Web Request method and my Description field value is { "orderNumber" : "AT-233570517", "poNumber" : null, "createdDate" : "2023-04-04T03:48:54.821-0500", "dueDate" : "2023-05-04T00:00:00.000-0500", "billingContact" : { "companyName" : "involit", "firstName" : "Involit", "lastName" : "Sales", "email" : "sales@involit.com", "phone" : "xxxx", "taxId" : "xxxx", "address" : { "address1" : "Ihlamur Yıldız Cad. 28-30", "address2" : "", "city" : "Istanbul", "postalCode" : "34353", "state" : "Beşiktaş", "country" : "Turkey" } }, "technicalContact" : { "companyName" : "yxxxx@xxxxx.com.tr", "firstName" : "xxxxs", "lastName" : "xxxxxx", "email" : "yxxxxx@axxxxxx.com.tr", "phone" : "", "taxId" : "", "address" : { "address1" : "xxxxx", "address2" : "xxxx", "city" : "xxxxtyu", "postalCode" : "xxx777", "state" : "", "country" : "Turkey" } }, "currency" : "USD", "partnerName" : "involit", "orderItems" : [ { "productName" : "Atlassian Cloud", "startDate" : "2023-05-03T00:00:00.000-0500", "endDate" : "2024-05-03T00:00:00.000-0500", "licensedTo" : "xxxxx@xxx.com.tr", "description" : "Atlassian Cloud (Annual Payments) Converted from Monthly Payments", "edition" : null, "cloudSiteHostname" : "xxxxxx.atlassian.net", "supportEntitlementNumber" : "SEN-3xxx", "cloudId" : "cb3a72b9-cf37-452xxxxx9a0", "cloudSiteUrl" : "https://abalioglu-holding.atlassian.net", "saleType" : "RENEWAL", "unitPrice" : 0.00, "platform" : "CLOUD", "taxExempt" : false, "licenseType" : "COMMERCIAL", "unitCount" : 987654321, "isTrialPeriod" : false, "isUnlimitedUsers" : true, "maintenanceMonths" : 12, "priceAdjustment" : 0, "upgradeCredit" : 0.00, "partnerDiscountTotal" : 0, "loyaltyDiscountTotal" : 0, "discounts" : [ ], "total" : 0.00 }, { "productName" : "Jira Service Management (Cloud)", "startDate" : "2023-05-03T00:00:00.000-0500", "endDate" : "2024-05-03T00:00:00.000-0500", "licensedTo" : "yuxxxxxx@axxxxx.com.tr", "description" : "Jira Service Management (Cloud) Standard 10 Agents (Annual Payments) Converted from Monthly Payments", "edition" : "standard", "cloudSiteHostname" : "xxxxx.atlassian.net", "supportEntitlementNumber" : "SEN-39276365", "entitlementNumber" : "E-3YW-TKV-SZG-AA5", "saleType" : "UPGRADE", "unitPrice" : 10.00, "platform" : "CLOUD", "taxExempt" : false, "licenseType" : "COMMERCIAL", "unitCount" : 10, "isTrialPeriod" : false, "isUnlimitedUsers" : false, "maintenanceMonths" : 12, "priceAdjustment" : 10.00, "upgradeCredit" : 0.00, "partnerDiscountTotal" : 10.00, "loyaltyDiscountTotal" : 0, "discounts" : [ { "amount" : 10.00, "percentage" : 30.00, "reason" : "PARTNER_DISCOUNT", "type" : "EXPERT" } ], "total" : 100.00 }, { "productName" : "Jira Software (Cloud)", "startDate" : "2023-04-14T00:00:00.000-0500", "endDate" : "2024-05-03T00:00:00.000-0500", "licensedTo" : "yxxxx@axxxxxx.com.tr", "description" : "Jira Software (Cloud) Standard 15 Users (Annual Payments) Converted from Monthly Payments", "edition" : "standard", "cloudSiteHostname" : "xxxx.atlassian.net", "supportEntitlementNumber" : "SEN-3xxxxx73", "entitlementNumber" : "E-3xxxxxxQ-AQX", "saleType" : "NEW", "unitPrice" : 1263.00, "platform" : "CLOUD", "taxExempt" : false, "licenseType" : "COMMERCIAL", "unitCount" : 15, "isTrialPeriod" : false, "isUnlimitedUsers" : false, "maintenanceMonths" : null, "priceAdjustment" : 0, "upgradeCredit" : 0.00, "partnerDiscountTotal" : 0, "loyaltyDiscountTotal" : 0, "discounts" : [ ], "total" : 1263.00 }, { "productName" : "Confluence (Cloud)", "startDate" : "2023-05-03T00:00:00.000-0500", "endDate" : "2024-05-03T00:00:00.000-0500", "licensedTo" : "yxxxxxx@xxxxx.com.tr", "description" : "Confluence (Cloud) Standard 10 Users (Annual Payments) Converted from Monthly Payments", "edition" : "standard", "cloudSiteHostname" : "axxxx.atlassian.net", "supportEntitlementNumber" : "SEN-xxxx1", "entitlementNumber" : "E-3Yxxxx-2YU", "saleType" : "NEW", "unitPrice" : 10.00, "platform" : "CLOUD", "taxExempt" : false, "licenseType" : "COMMERCIAL", "unitCount" : 10, "isTrialPeriod" : false, "isUnlimitedUsers" : false, "maintenanceMonths" : 12, "priceAdjustment" : 0, "upgradeCredit" : 0.00, "partnerDiscountTotal" : 0, "loyaltyDiscountTotal" : 0, "discounts" : [ ], "total" : 20.00 } ], "totalExTax" : 33.00, "totalIncTax" : 13.00, "totalTax" : 0.00 }

4

Thanks for your back @mventnor
I am using Web Request and the JSOn data comes from description field.

image
image1920×1126 104 KB

Description JSON{ "orderNumber" : "AT-233570517", "poNumber" : null, "createdDate" : "2023-04-04T03:48:54.821-0500", "dueDate" : "2023-05-04T00:00:00.000-0500", "billingContact" : { "companyName" : "involit", "firstName" : "Involit", "lastName" : "Sales", "email" : "sales@involit.com", "phone" : "xxxx", "taxId" : "xxxx", "address" : { "address1" : "Ihlamur Yıldız Cad. 28-30", "address2" : "", "city" : "Istanbul", "postalCode" : "34353", "state" : "Beşiktaş", "country" : "Turkey" } }, "technicalContact" : { "companyName" : "yxxxx@xxxxx.com.tr", "firstName" : "xxxxs", "lastName" : "xxxxxx", "email" : "yxxxxx@axxxxxx.com.tr", "phone" : "", "taxId" : "", "address" : { "address1" : "xxxxx", "address2" : "xxxx", "city" : "xxxxtyu", "postalCode" : "xxx777", "state" : "", "country" : "Turkey" } }, "currency" : "USD", "partnerName" : "involit", "orderItems" : [ { "productName" : "Atlassian Cloud", "startDate" : "2023-05-03T00:00:00.000-0500", "endDate" : "2024-05-03T00:00:00.000-0500", "licensedTo" : "xxxxx@xxx.com.tr", "description" : "Atlassian Cloud (Annual Payments) Converted from Monthly Payments", "edition" : null, "cloudSiteHostname" : "xxxxxx.atlassian.net", "supportEntitlementNumber" : "SEN-3xxx", "cloudId" : "cb3a72b9-cf37-452xxxxx9a0", "cloudSiteUrl" : "https://abalioglu-holding.atlassian.net", "saleType" : "RENEWAL", "unitPrice" : 0.00, "platform" : "CLOUD", "taxExempt" : false, "licenseType" : "COMMERCIAL", "unitCount" : 987654321, "isTrialPeriod" : false, "isUnlimitedUsers" : true, "maintenanceMonths" : 12, "priceAdjustment" : 0, "upgradeCredit" : 0.00, "partnerDiscountTotal" : 0, "loyaltyDiscountTotal" : 0, "discounts" : [ ], "total" : 0.00 }, { "productName" : "Jira Service Management (Cloud)", "startDate" : "2023-05-03T00:00:00.000-0500", "endDate" : "2024-05-03T00:00:00.000-0500", "licensedTo" : "yuxxxxxx@axxxxx.com.tr", "description" : "Jira Service Management (Cloud) Standard 10 Agents (Annual Payments) Converted from Monthly Payments", "edition" : "standard", "cloudSiteHostname" : "xxxxx.atlassian.net", "supportEntitlementNumber" : "SEN-39276365", "entitlementNumber" : "E-3YW-TKV-SZG-AA5", "saleType" : "UPGRADE", "unitPrice" : 10.00, "platform" : "CLOUD", "taxExempt" : false, "licenseType" : "COMMERCIAL", "unitCount" : 10, "isTrialPeriod" : false, "isUnlimitedUsers" : false, "maintenanceMonths" : 12, "priceAdjustment" : 10.00, "upgradeCredit" : 0.00, "partnerDiscountTotal" : 10.00, "loyaltyDiscountTotal" : 0, "discounts" : [ { "amount" : 10.00, "percentage" : 30.00, "reason" : "PARTNER_DISCOUNT", "type" : "EXPERT" } ], "total" : 100.00 }, { "productName" : "Jira Software (Cloud)", "startDate" : "2023-04-14T00:00:00.000-0500", "endDate" : "2024-05-03T00:00:00.000-0500", "licensedTo" : "yxxxx@axxxxxx.com.tr", "description" : "Jira Software (Cloud) Standard 15 Users (Annual Payments) Converted from Monthly Payments", "edition" : "standard", "cloudSiteHostname" : "xxxx.atlassian.net", "supportEntitlementNumber" : "SEN-3xxxxx73", "entitlementNumber" : "E-3xxxxxxQ-AQX", "saleType" : "NEW", "unitPrice" : 1263.00, "platform" : "CLOUD", "taxExempt" : false, "licenseType" : "COMMERCIAL", "unitCount" : 15, "isTrialPeriod" : false, "isUnlimitedUsers" : false, "maintenanceMonths" : null, "priceAdjustment" : 0, "upgradeCredit" : 0.00, "partnerDiscountTotal" : 0, "loyaltyDiscountTotal" : 0, "discounts" : [ ], "total" : 1263.00 }, { "productName" : "Confluence (Cloud)", "startDate" : "2023-05-03T00:00:00.000-0500", "endDate" : "2024-05-03T00:00:00.000-0500", "licensedTo" : "yxxxxxx@xxxxx.com.tr", "description" : "Confluence (Cloud) Standard 10 Users (Annual Payments) Converted from Monthly Payments", "edition" : "standard", "cloudSiteHostname" : "axxxx.atlassian.net", "supportEntitlementNumber" : "SEN-xxxx1", "entitlementNumber" : "E-3Yxxxx-2YU", "saleType" : "NEW", "unitPrice" : 10.00, "platform" : "CLOUD", "taxExempt" : false, "licenseType" : "COMMERCIAL", "unitCount" : 10, "isTrialPeriod" : false, "isUnlimitedUsers" : false, "maintenanceMonths" : 12, "priceAdjustment" : 0, "upgradeCredit" : 0.00, "partnerDiscountTotal" : 0, "loyaltyDiscountTotal" : 0, "discounts" : [ ], "total" : 20.00 } ], "totalExTax" : 33.00, "totalIncTax" : 13.00, "totalTax" : 0.00 }