• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

How get sum from an array

Jithin

Member
Your Task History ID
IjU3NmQwNTY5MDYzZjA0M2M1MjZjNTUzNDUxM2I1MTYxNTQzMiI_3D_pc
I'm working with Square webhooks and I'm sending an invoice with Deposit + Multiple Installment structure. They are all under payment request array. So I'm accepting the webhook data as raw data so that I can work with array instead of single elements. I've stored the raw array to an iterator thinking that I'd be able to SUM the output of the iterator to get the total amount paid etc. But apparently its not working. How would you go about summing up values in an array or otherwise where the number of elements to add up is not fixed and changes depending on the use case.
 
P

Pabblymember11

Guest
Hey @Jithin

Please provide the reference of the specific JSON array value you wish to calculate from Square's webhook response, so we can explore the possibilities.
 

Jithin

Member
[
{
"automatic_payment_source": "NONE",
"computed_amount_money": {
"amount": 20000,
"currency": "AUD"
},
"due_date": "2024-06-19",
"fixed_amount_requested_money": {
"amount": 20000,
"currency": "AUD"
},
"reminders": [
{
"relative_scheduled_days": -7,
"status": "NOT_APPLICABLE",
"uid": "95d7ec33-1a32-425d-bdeb-8e5f"
},
{
"relative_scheduled_days": 0,
"status": "NOT_APPLICABLE",
"uid": "e9bf2073-425e-4141-8a81-5f0edfc1"
},
{
"relative_scheduled_days": 1,
"status": "NOT_APPLICABLE",
"uid": "c6b9bd38-2b6c-4bda-b8b6928e528d"
},
{
"relative_scheduled_days": 3,
"status": "NOT_APPLICABLE",
"uid": "b44e2604-8a72-4618-9fdc-4be228df"
}
],
"request_type": "DEPOSIT",
"tipping_enabled": false,
"total_completed_amount_money": {
"amount": 20000,
"currency": "AUD"
},
"uid": "0eb4d1cd-42ff-4d25-b286-15de9a5"
},
{
"automatic_payment_source": "NONE",
"computed_amount_money": {
"amount": 136000,
"currency": "AUD"
},
"due_date": "2024-07-17",
"fixed_amount_requested_money": {
"amount": 136000,
"currency": "AUD"
},
"reminders": [
{
"relative_scheduled_days": -7,
"sent_at": "2024-07-10T01:04:05Z",
"status": "SENT",
"uid": "7d8c2428-90a0-4d34-b163-1108b6ee"
},
{
"relative_scheduled_days": 0,
"status": "NOT_APPLICABLE",
"uid": "f42a689c-e27e-4b55-9f47-a0f7fb9ef"
},
{
"relative_scheduled_days": 1,
"status": "NOT_APPLICABLE",
"uid": "f2efdf14-415f-4439-a750-21b9cbf97"
},
{
"relative_scheduled_days": 3,
"status": "NOT_APPLICABLE",
"uid": "5a4da270-930c-473b-bb14-5bc8b1a46"
}
],
"request_type": "INSTALLMENT",
"tipping_enabled": false,
"total_completed_amount_money": {
"amount": 136000,
"currency": "AUD"
},
"uid": "69a88790-3ae6-40d5-b87d-075d14"
},
{
"automatic_payment_source": "NONE",
"computed_amount_money": {
"amount": 86000,
"currency": "AUD"
},
"due_date": "2024-07-18",
"fixed_amount_requested_money": {
"amount": 86000,
"currency": "AUD"
},
"reminders": [
{
"relative_scheduled_days": -7,
"status": "NOT_APPLICABLE",
"uid": "837a7718-c8de-497f-a9ec-a37260c65"
},
{
"relative_scheduled_days": 0,
"status": "NOT_APPLICABLE",
"uid": "fb717b18-3a44-4488-b51e-1ff0af239"
},
{
"relative_scheduled_days": 1,
"status": "NOT_APPLICABLE",
"uid": "3a89301a-5bd6-4ecb-ac75-8f112969"
},
{
"relative_scheduled_days": 3,
"status": "NOT_APPLICABLE",
"uid": "6ea62a6f-96e4-40df-ace2-50427fc22f"
}
],
"request_type": "INSTALLMENT",
"tipping_enabled": false,
"total_completed_amount_money": {
"amount": 86000,
"currency": "AUD"
},
"uid": "adccbcb9-0acb-4459-99d9-6b107c5c2"
},
{
"automatic_payment_source": "NONE",
"computed_amount_money": {
"amount": 50000,
"currency": "AUD"
},
"due_date": "2024-07-20",
"fixed_amount_requested_money": {
"amount": 50000,
"currency": "AUD"
},
"reminders": [
{
"relative_scheduled_days": -7,
"status": "NOT_APPLICABLE",
"uid": "27ec1301-509a-4fbe-acd0-2b7d93a04b10"
},
{
"relative_scheduled_days": 0,
"status": "PENDING",
"uid": "36c50af6-59c9-46b5-90d0-43f2a76a6698"
},
{
"relative_scheduled_days": 1,
"status": "PENDING",
"uid": "5affd51b-b2f5-465e-be84-3dc3aa919d5a"
},
{
"relative_scheduled_days": 3,
"status": "PENDING",
"uid": "e9451e34-2fce-4e9c-ad58-07242da9a402"
}
],
"request_type": "INSTALLMENT",
"tipping_enabled": false,
"total_completed_amount_money": {
"amount": 0,
"currency": "AUD"
},
"uid": "d1e6aed5-779e-4434-89e3cc1645f6de"
}
]


This is the array I'm sending to iterator and want to get the value of "computed_amount_money" and add them up.
 

Jithin

Member
After sending this here, got an idea and it worked. If anyone comes across similar issue, use a code block to iterate through the json and compute the sum (or do any operations). Though I'd still be interested in knowing how to use iterator element in this situation as a no code solution.
 
Top