Summarizing specific items on array of collections

How To
,
1

I have a bundle that contains an array of collections.
I would like to iterate this array and summarize a certain field in the collection only if a certain condition meets.
I have this JSON:
[
{
“id”: “”,
“customer_id”: “”,
“subscription_id”: “AzZnCGU90AeYW3gSB”,
“line_items”: [
{
“id”: “li_16BdPXUEhMeu1CT2f”,
“date_from”: 1717473600,
“date_to”: 1720065599,
“amount”: 8100,
“entity_type”: “addon_item_price”,
“entity_id”: “Monthly-Insurance-Premium-USD-Monthly”,
“tax_exempt_reason”: “tax_not_configured”,
“discount_amount”: 0,
“item_level_discount_amount”: 0
},
{
“id”: “li_16BdPXUEhMeu1CT33”,
“date_from”: 1717473600,
“date_to”: 1720065599,
“amount”: 8100,
“entity_type”: “addon_item_price”,
“entity_id”: “Monthly-Insurance-Premium-USD-fee”,
“tax_exempt_reason”: “tax_not_configured”,
“discount_amount”: 0,
“item_level_discount_amount”: 0
}
],
}
]
I would like to summarize the line items amount only if the entity_id contains the “fee” word.
I will appreciate help with that.

1 Like
2

Welcome to the Make community!

Your JSON is now invalid because you forgot to format the code in the rich-text editor.

1. This forum might have or already changed your text

When pasting text into this forum, you should format the example text using the rich-text editor, otherwise the forum software might modify the displayed text, and you might get incorrect answers from others because of it.

Some things this forum software might do to mangle your text:

– remove extra spaces (which may be necessary)
– convert links to titles (when copied is incorrect)
– incorrect joined links
– convert single and double quotes to smart angled quotes ()
– emojis
– etc.

This interferes with you receiving correct answers, because it:

– makes JSON invalid (you can verify when copy-paste into https://jsonformatter.org)
– makes incorrect text examples when we need to build a pattern for text parsing

2. To prevent this in future, please format text in code blocks

A. Type code fence manually
Either add three backticks ``` before and after the text, like this:

```
content goes here
```

B. Highlight and click the format button
Or use the format code button in the editor:
Screenshot_2023-10-02_191027

3. You might need to re-copy the original text

Once the post has been submitted, it’s too late to format it since it’s already butchered, and you need to make a re-copy of the text, and format it before submitting the forum post.

Please let us know once you have corrected the issue. This will avoid others potentially providing wrong answers based on incorrect text in your question.

Thank you!

Join the Make Fans Discord server to chat with other makers!

2 Likes
3

Hi @Eli_Lila ,

Welcome to Make Community!

We are really happy to help you with this roadblock. Please check the image and description below.

  1. Iterate the line items and use the Text Aggregator module as shown below.

    image
    image1585×587 77.1 KB

  2. Map the line item array to the iterator and then set up a filter in between the Iterator and Text Aggregator.

image
image1067×562 45.5 KB

image
image755×749 62.3 KB

Final Output:-

image
image827×590 40.6 KB

From the given JSON, only one line item passed the filter. I hope this is what you are looking for.

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
| Book Live Implementation
Visit us here
Youtube Channel

2 Likes
4

Thank you @Msquare_Automation

1 Like
5

Hello again @Msquare_Automation
I have a more complicated use case where I need to have a nested iterations.
I’m attaching some screenshots

image
image1135×294 34.8 KB

I have an array of “Credit Notes”, I’m iterating the array and fetch the credit note and for credit note I have an array of collection of line items.
For each line item, I summarize the amount (assuming it has fee).
And then, I put two consecutive numeric aggregators and I would like to keep the final result in some variable.
I guess I’m doing something wrong with these numeric aggregators.

6

Here’s the correct JSON

[
    {
        "id": "",
        "customer_id": "",
        "subscription_id": "AzZnCGU90AeYW3gSB",
        "line_items": [
            {
                "id": "li_16BdPXUEhMeu1CT2f",
                "date_from": 1717473600,
                "date_to": 1720065599,
                "amount": 8100,
                "entity_type": "addon_item_price",
                "entity_id": "Monthly-Insurance-Premium-USD-Monthly",
                "tax_exempt_reason": "tax_not_configured",
                "discount_amount": 0,
                "item_level_discount_amount": 0
            },
            {
                "id": "li_16BdPXUEhMeu1CT33",
                "date_from": 1717473600,
                "date_to": 1720065599,
                "amount": 8100,
                "entity_type": "addon_item_price",
                "entity_id": "Monthly-Insurance-Premium-USD-fee",
                "tax_exempt_reason": "tax_not_configured",
                "discount_amount": 0,
                "item_level_discount_amount": 0
            }
        ]
    }
]

It would be nice to use the array functions and accomplish this in one operation… Thinking of using map() with the key filtering capability but need to find all entity_id values that contains ‘fee’ - indexOf() can return occurences of a substring… :question:

I figure if you know the name of the entity_id’s you wish to omit you can do this:

{{omit(toCollection(1.line_items; "entity_id"; "amount"); "Monthly-Insurance-Premium-USD-Monthly")}}

This will convert the line_items array into a collection where the entity_id value is the keyname, and the amount value is the value of the new key. Then you can use omit() to remove the keys from the collection you don’t want yielding:

[
    {
        "result": {
            "Monthly-Insurance-Premium-USD-fee": 8200,
            "Yearly-Insurance-Premium-USD-fee": 8300
        }
    }
]

given this JSON:

[
    {
        "id": "",
        "customer_id": "",
        "subscription_id": "AzZnCGU90AeYW3gSB",
        "line_items": [
            {
                "id": "li_16BdPXUEhMeu1CT2f",
                "date_from": 1717473600,
                "date_to": 1720065599,
                "amount": 8100,
                "entity_type": "addon_item_price",
                "entity_id": "Monthly-Insurance-Premium-USD-Monthly",
                "tax_exempt_reason": "tax_not_configured",
                "discount_amount": 0,
                "item_level_discount_amount": 0
            },
            {
                "id": "li_16BdPXUEhMeu1CT33",
                "date_from": 1717473600,
                "date_to": 1720065599,
                "amount": 8200,
                "entity_type": "addon_item_price",
                "entity_id": "Monthly-Insurance-Premium-USD-fee",
                "tax_exempt_reason": "tax_not_configured",
                "discount_amount": 0,
                "item_level_discount_amount": 0
            },{
                "id": "li_16BdPXUEhMeu1CT33",
                "date_from": 1717473600,
                "date_to": 1720065599,
                "amount": 8300,
                "entity_type": "addon_item_price",
                "entity_id": "Yearly-Insurance-Premium-USD-fee",
                "tax_exempt_reason": "tax_not_configured",
                "discount_amount": 0,
                "item_level_discount_amount": 0
            }
        ]
    }
]
1 Like
7

Thanks @alex.newpath. The solution that @Msquare_Automation proposed works.
However, I found out that the use case is more complicated as I need to have nested iterations.
I have another array of collection “Issued credit notes” in the same JSON and for each item, I need to retrieve credit note and iterate its line items and summarize the amount.
“issued_credit_notes”: [
{
“cn_id”: “AHOY-CN-2024-06-15”,
“cn_reason_code”: “other”,
“cn_create_reason_code”: “MTA Credit”,
“cn_date”: 1718279671,
“cn_total”: 4500,
“cn_status”: “refunded”
},
{
“cn_id”: “AHOY-CN-2024-06-16”,
“cn_reason_code”: “other”,
“cn_create_reason_code”: “MTA Credit”,
“cn_date”: 1718279776,
“cn_total”: 6500,
“cn_status”: “refunded”
}
]

Where each credit note object has the following structure:
{
“body”: {
“credit_note”: {
“id”: “AHOY-CN-2024-06-16”,
“customer_id”: “17007777444”,
“subscription_id”: “AzqC1oU3hvsYiW5t”,
“reference_invoice_id”: “AHOY-2024-06-662”,
“type”: “refundable”,
“reason_code”: “other”,
“status”: “refunded”,
“date”: 1718279776,
“price_type”: “tax_exclusive”,
“exchange_rate”: 1,
“total”: 6500,
“amount_allocated”: 0,
“amount_refunded”: 6500,
“amount_available”: 0,
“refunded_at”: 1718279807,
“generated_at”: 1718279776,
“updated_at”: 1718279807,
“channel”: “web”,
“resource_version”: 1718279807412,
“deleted”: false,
“object”: “credit_note”,
“create_reason_code”: “MTA Credit”,
“currency_code”: “USD”,
“round_off_amount”: 0,
“fractional_correction”: 0,
“base_currency_code”: “USD”,
“sub_total”: 6500,
“line_items”: [
{
“id”: “li_16BPfIUFZupUvBxH”,
“date_from”: 1718251200,
“date_to”: 1718337599,
“unit_amount”: 1000,
“quantity”: 1,
“amount”: 1000,
“pricing_model”: “flat_fee”,
“is_taxed”: false,
“tax_amount”: 0,
“object”: “line_item”,
“subscription_id”: “AzqC1oU3hvsYiW5t”,
“customer_id”: “17007777444”,
“description”: “Late payment fee”,
“entity_type”: “charge_item_price”,
“entity_id”: “Late-payment-fee-USD”,
“reference_line_item_id”: “li_16CRicUFZtNmQA9W”,
“tax_exempt_reason”: “tax_not_configured”,
“discount_amount”: 0,
“item_level_discount_amount”: 0
},
{
“id”: “li_16BPfIUFZupUwBxI”,
“date_from”: 1718251200,
“date_to”: 1718337599,
“unit_amount”: 500,
“quantity”: 1,
“amount”: 500,
“pricing_model”: “flat_fee”,
“is_taxed”: false,
“tax_amount”: 0,
“object”: “line_item”,
“subscription_id”: “AzqC1oU3hvsYiW5t”,
“customer_id”: “17007777444”,
“description”: “Handling fees”,
“entity_type”: “charge_item_price”,
“entity_id”: “First-Installment-handling-fee-USD”,
“reference_line_item_id”: “li_16CRicUFZtNmUA9Y”,
“tax_exempt_reason”: “tax_not_configured”,
“discount_amount”: 0,
“item_level_discount_amount”: 0
},
{
“id”: “li_16BPfIUFZupUxBxJ”,
“date_from”: 1718251200,
“date_to”: 1718337599,
“unit_amount”: 5000,
“quantity”: 1,
“amount”: 5000,
“pricing_model”: “flat_fee”,
“is_taxed”: false,
“tax_amount”: 0,
“object”: “line_item”,
“subscription_id”: “AzqC1oU3hvsYiW5t”,
“customer_id”: “17007777444”,
“description”: “Ahoy! Insurance - Mid-Term Policy Adjustments”,
“entity_type”: “charge_item_price”,
“entity_id”: “MTA-PremiumCharge-USD”,
“reference_line_item_id”: “li_16CRicUFZtNmVA9Z”,
“tax_exempt_reason”: “tax_not_configured”,
“discount_amount”: 0,
“item_level_discount_amount”: 0
}
],
“taxes”: ,
“line_item_taxes”: ,
“line_item_discounts”: ,
“linked_refunds”: [
{
“applied_amount”: 6500,
“applied_at”: 1718279807,
“txn_id”: “txn_16BPfIUFZuxN2Bxp”,
“txn_status”: “success”,
“txn_date”: 1718279806,
“txn_amount”: 6500,
“refund_reason_code”: “Other”
}
],
“allocations”: ,
“billing_address”: {
“first_name”: “Test”,
“last_name”: “Pm1”,
“line1”: “5555 Cleveland Ave”,
“city”: “Columbus”,
“state_code”: “OH”,
“state”: “Ohio”,
“country”: “US”,
“zip”: “43231”,
“validation_status”: “not_validated”,
“object”: “billing_address”
},
“shipping_address”: {
“first_name”: “Test”,
“last_name”: “Pm1”,
“line1”: “5555 Cleveland Ave”,
“city”: “Columbus”,
“state_code”: “OH”,
“state”: “Ohio”,
“country”: “US”,
“zip”: “43231”,
“validation_status”: “not_validated”,
“object”: “shipping_address”
},
“customer_notes”: “”,
“site_details_at_creation”: {
“timezone”: “America/New_York”,
“organization_address”: {
“organization_name”: “Ahoy Insurance”,
“email”: “billing@ahoy.insure”,
“line1”: “2329 Nostrand Ave.”,
“line2”: “Suite 100”,
“city”: “Brooklyn”,
“state_code”: “NY”,
“state”: “New York”,
“country_code”: “US”,
“zip”: “11210”,
“phone”: “8552892469”,
“website”: “http://www.ahoy.insure”
}
},
“tax_origin”: {
“country”: “US”
}
}
},
“headers”: {
“date”: “Thu, 13 Jun 2024 12:02:21 GMT”,
“content-type”: “application/json;charset=utf-8”,
“content-length”: “4919”,
“connection”: “close”,
“cache-control”: “no-store, no-cache, must-revalidate”,
“expires”: “Thu, 01 Jan 1970 00:00:00 UTC”,
“strict-transport-security”: “max-age=31536000; includeSubDomains; preload”,
“pragma”: “no-cache”,
“x-content-type-options”: “nosniff”,
“vary”: “Accept-Encoding”,
“server”: “ChargeBee”
},
“statusCode”: 200
}

8

Can you share your whole blue print including the incoming full JSON inside the blueprint? Also what is the exact output you wish to produce?

1 Like
9

blueprint.json (123.0 KB)
Attached is the blue print
Below you can find the result of retrieving the invoice from Chargebee (2nd operation):
[
{
“id”: “AHOY-2024-06-662”,
“customer_id”: “17007777444”,
“subscription_id”: “AzqC1oU3hvsYiW5t”,
“recurring”: false,
“status”: “paid”,
“price_type”: “tax_exclusive”,
“date”: 1718279431,
“due_date”: 1718279431,
“net_term_days”: 0,
“exchange_rate”: 1,
“total”: 15000,
“amount_paid”: 15000,
“amount_adjusted”: 0,
“write_off_amount”: 0,
“credits_applied”: 0,
“amount_due”: 0,
“paid_at”: 1718279431,
“updated_at”: 1718279807,
“resource_version”: 1718279807411,
“deleted”: false,
“object”: “invoice”,
“first_invoice”: false,
“amount_to_collect”: 0,
“round_off_amount”: 0,
“has_advance_charges”: false,
“currency_code”: “USD”,
“base_currency_code”: “USD”,
“generated_at”: 1718279431,
“is_gifted”: false,
“term_finalized”: true,
“channel”: “web”,
“tax”: 0,
“line_items”: [
{
“id”: “li_16CRicUFZtNmQA9W”,
“date_from”: 1718251200,
“date_to”: 1718337599,
“unit_amount”: 4500,
“quantity”: 1,
“amount”: 4500,
“pricing_model”: “flat_fee”,
“is_taxed”: false,
“tax_amount”: 0,
“object”: “line_item”,
“subscription_id”: “AzqC1oU3hvsYiW5t”,
“customer_id”: “17007777444”,
“description”: “Late payment fee”,
“entity_type”: “charge_item_price”,
“entity_id”: “Late-payment-fee-USD”,
“tax_exempt_reason”: “tax_not_configured”,
“discount_amount”: 0,
“item_level_discount_amount”: 0
},
{
“id”: “li_16CRicUFZtNmUA9Y”,
“date_from”: 1718251200,
“date_to”: 1718337599,
“unit_amount”: 500,
“quantity”: 1,
“amount”: 500,
“pricing_model”: “flat_fee”,
“is_taxed”: false,
“tax_amount”: 0,
“object”: “line_item”,
“subscription_id”: “AzqC1oU3hvsYiW5t”,
“customer_id”: “17007777444”,
“description”: “Handling fees”,
“entity_type”: “charge_item_price”,
“entity_id”: “First-Installment-handling-fee-USD”,
“tax_exempt_reason”: “tax_not_configured”,
“discount_amount”: 0,
“item_level_discount_amount”: 0
},
{
“id”: “li_16CRicUFZtNmVA9Z”,
“date_from”: 1718251200,
“date_to”: 1718337599,
“unit_amount”: 10000,
“quantity”: 1,
“amount”: 10000,
“pricing_model”: “flat_fee”,
“is_taxed”: false,
“tax_amount”: 0,
“object”: “line_item”,
“subscription_id”: “AzqC1oU3hvsYiW5t”,
“customer_id”: “17007777444”,
“description”: “Ahoy! Insurance - Mid-Term Policy Adjustments”,
“entity_type”: “charge_item_price”,
“entity_id”: “MTA-PremiumCharge-USD”,
“tax_exempt_reason”: “tax_not_configured”,
“discount_amount”: 0,
“item_level_discount_amount”: 0
}
],
“sub_total”: 15000,
“linked_payments”: [
{
“txn_id”: “txn_16CRicUFZtNoKA9b”,
“applied_amount”: 15000,
“applied_at”: 1718279432,
“txn_status”: “success”,
“txn_date”: 1718279431,
“txn_amount”: 15000
}
],
“applied_credits”: ,
“adjustment_credit_notes”: ,
“issued_credit_notes”: [
{
“cn_id”: “AHOY-CN-2024-06-15”,
“cn_reason_code”: “other”,
“cn_create_reason_code”: “MTA Credit”,
“cn_date”: 1718279671,
“cn_total”: 4500,
“cn_status”: “refunded”
},
{
“cn_id”: “AHOY-CN-2024-06-16”,
“cn_reason_code”: “other”,
“cn_create_reason_code”: “MTA Credit”,
“cn_date”: 1718279776,
“cn_total”: 6500,
“cn_status”: “refunded”
}
],
“linked_orders”: ,
“dunning_attempts”: ,
“billing_address”: {
“first_name”: “Test”,
“last_name”: “Pm1”,
“line1”: “5555 Cleveland Ave”,
“city”: “Columbus”,
“state_code”: “OH”,
“state”: “Ohio”,
“country”: “US”,
“zip”: “43231”,
“validation_status”: “not_validated”,
“object”: “billing_address”
},
“shipping_address”: {
“first_name”: “Test”,
“last_name”: “Pm1”,
“line1”: “5555 Cleveland Ave”,
“city”: “Columbus”,
“state_code”: “OH”,
“state”: “Ohio”,
“country”: “US”,
“zip”: “43231”,
“validation_status”: “not_validated”,
“object”: “shipping_address”
},
“site_details_at_creation”: {
“timezone”: “America/New_York”,
“organization_address”: {
“organization_name”: “Ahoy Insurance”,
“email”: “billing@ahoy.insure”,
“line1”: “2329 Nostrand Ave.”,
“line2”: “Suite 100”,
“city”: “Brooklyn”,
“state_code”: “NY”,
“state”: “New York”,
“country_code”: “US”,
“zip”: “11210”,
“phone”: “8552892469”,
“website”: “http://www.ahoy.insure”
}
},
“tax_origin”: {
“country”: “US”
}
}
]

Below you can find the output of the other operation for retrieving credit note:
[
{
“body”: {
“credit_note”: {
“id”: “AHOY-CN-2024-06-15”,
“customer_id”: “17007777444”,
“subscription_id”: “AzqC1oU3hvsYiW5t”,
“reference_invoice_id”: “AHOY-2024-06-662”,
“type”: “refundable”,
“reason_code”: “other”,
“status”: “refunded”,
“date”: 1718279671,
“price_type”: “tax_exclusive”,
“exchange_rate”: 1,
“total”: 4500,
“amount_allocated”: 0,
“amount_refunded”: 4500,
“amount_available”: 0,
“refunded_at”: 1718279684,
“generated_at”: 1718279671,
“updated_at”: 1718279684,
“channel”: “web”,
“resource_version”: 1718279684574,
“deleted”: false,
“object”: “credit_note”,
“create_reason_code”: “MTA Credit”,
“currency_code”: “USD”,
“round_off_amount”: 0,
“fractional_correction”: 0,
“base_currency_code”: “USD”,
“sub_total”: 4500,
“line_items”: [
{
“id”: “li_16BPfIUFZuON5Bw7”,
“date_from”: 1718251200,
“date_to”: 1718337599,
“unit_amount”: 2500,
“quantity”: 1,
“amount”: 2500,
“pricing_model”: “flat_fee”,
“is_taxed”: false,
“tax_amount”: 0,
“object”: “line_item”,
“subscription_id”: “AzqC1oU3hvsYiW5t”,
“customer_id”: “17007777444”,
“description”: “Late payment fee”,
“entity_type”: “charge_item_price”,
“entity_id”: “Late-payment-fee-USD”,
“reference_line_item_id”: “li_16CRicUFZtNmQA9W”,
“tax_exempt_reason”: “tax_not_configured”,
“discount_amount”: 0,
“item_level_discount_amount”: 0
},
{
“id”: “li_16BPfIUFZuON7Bw8”,
“date_from”: 1718251200,
“date_to”: 1718337599,
“unit_amount”: 2000,
“quantity”: 1,
“amount”: 2000,
“pricing_model”: “flat_fee”,
“is_taxed”: false,
“tax_amount”: 0,
“object”: “line_item”,
“subscription_id”: “AzqC1oU3hvsYiW5t”,
“customer_id”: “17007777444”,
“description”: “Ahoy! Insurance - Mid-Term Policy Adjustments”,
“entity_type”: “charge_item_price”,
“entity_id”: “MTA-PremiumCharge-USD”,
“reference_line_item_id”: “li_16CRicUFZtNmVA9Z”,
“tax_exempt_reason”: “tax_not_configured”,
“discount_amount”: 0,
“item_level_discount_amount”: 0
}
],
“taxes”: ,
“line_item_taxes”: ,
“line_item_discounts”: ,
“linked_refunds”: [
{
“applied_amount”: 4500,
“applied_at”: 1718279684,
“txn_id”: “txn_169vuDUFZuRPqAvg”,
“txn_status”: “success”,
“txn_date”: 1718279683,
“txn_amount”: 4500,
“refund_reason_code”: “Other”
}
],
“allocations”: ,
“billing_address”: {
“first_name”: “Test”,
“last_name”: “Pm1”,
“line1”: “5555 Cleveland Ave”,
“city”: “Columbus”,
“state_code”: “OH”,
“state”: “Ohio”,
“country”: “US”,
“zip”: “43231”,
“validation_status”: “not_validated”,
“object”: “billing_address”
},
“shipping_address”: {
“first_name”: “Test”,
“last_name”: “Pm1”,
“line1”: “5555 Cleveland Ave”,
“city”: “Columbus”,
“state_code”: “OH”,
“state”: “Ohio”,
“country”: “US”,
“zip”: “43231”,
“validation_status”: “not_validated”,
“object”: “shipping_address”
},
“customer_notes”: “”,
“site_details_at_creation”: {
“timezone”: “America/New_York”,
“organization_address”: {
“organization_name”: “Ahoy Insurance”,
“email”: “billing@ahoy.insure”,
“line1”: “2329 Nostrand Ave.”,
“line2”: “Suite 100”,
“city”: “Brooklyn”,
“state_code”: “NY”,
“state”: “New York”,
“country_code”: “US”,
“zip”: “11210”,
“phone”: “8552892469”,
“website”: “http://www.ahoy.insure”
}
},
“tax_origin”: {
“country”: “US”
}
}
},
“headers”: {
“date”: “Thu, 13 Jun 2024 12:02:21 GMT”,
“content-type”: “application/json;charset=utf-8”,
“content-length”: “4121”,
“connection”: “close”,
“cache-control”: “no-store, no-cache, must-revalidate”,
“expires”: “Thu, 01 Jan 1970 00:00:00 UTC”,
“strict-transport-security”: “max-age=31536000; includeSubDomains; preload”,
“pragma”: “no-cache”,
“x-content-type-options”: “nosniff”,
“vary”: “Accept-Encoding”,
“server”: “ChargeBee”
},
“statusCode”: 200
}
]

and another credit note:
[
{
“body”: {
“credit_note”: {
“id”: “AHOY-CN-2024-06-15”,
“customer_id”: “17007777444”,
“subscription_id”: “AzqC1oU3hvsYiW5t”,
“reference_invoice_id”: “AHOY-2024-06-662”,
“type”: “refundable”,
“reason_code”: “other”,
“status”: “refunded”,
“date”: 1718279671,
“price_type”: “tax_exclusive”,
“exchange_rate”: 1,
“total”: 4500,
“amount_allocated”: 0,
“amount_refunded”: 4500,
“amount_available”: 0,
“refunded_at”: 1718279684,
“generated_at”: 1718279671,
“updated_at”: 1718279684,
“channel”: “web”,
“resource_version”: 1718279684574,
“deleted”: false,
“object”: “credit_note”,
“create_reason_code”: “MTA Credit”,
“currency_code”: “USD”,
“round_off_amount”: 0,
“fractional_correction”: 0,
“base_currency_code”: “USD”,
“sub_total”: 4500,
“line_items”: [
{
“id”: “li_16BPfIUFZuON5Bw7”,
“date_from”: 1718251200,
“date_to”: 1718337599,
“unit_amount”: 2500,
“quantity”: 1,
“amount”: 2500,
“pricing_model”: “flat_fee”,
“is_taxed”: false,
“tax_amount”: 0,
“object”: “line_item”,
“subscription_id”: “AzqC1oU3hvsYiW5t”,
“customer_id”: “17007777444”,
“description”: “Late payment fee”,
“entity_type”: “charge_item_price”,
“entity_id”: “Late-payment-fee-USD”,
“reference_line_item_id”: “li_16CRicUFZtNmQA9W”,
“tax_exempt_reason”: “tax_not_configured”,
“discount_amount”: 0,
“item_level_discount_amount”: 0
},
{
“id”: “li_16BPfIUFZuON7Bw8”,
“date_from”: 1718251200,
“date_to”: 1718337599,
“unit_amount”: 2000,
“quantity”: 1,
“amount”: 2000,
“pricing_model”: “flat_fee”,
“is_taxed”: false,
“tax_amount”: 0,
“object”: “line_item”,
“subscription_id”: “AzqC1oU3hvsYiW5t”,
“customer_id”: “17007777444”,
“description”: “Ahoy! Insurance - Mid-Term Policy Adjustments”,
“entity_type”: “charge_item_price”,
“entity_id”: “MTA-PremiumCharge-USD”,
“reference_line_item_id”: “li_16CRicUFZtNmVA9Z”,
“tax_exempt_reason”: “tax_not_configured”,
“discount_amount”: 0,
“item_level_discount_amount”: 0
}
],
“taxes”: ,
“line_item_taxes”: ,
“line_item_discounts”: ,
“linked_refunds”: [
{
“applied_amount”: 4500,
“applied_at”: 1718279684,
“txn_id”: “txn_169vuDUFZuRPqAvg”,
“txn_status”: “success”,
“txn_date”: 1718279683,
“txn_amount”: 4500,
“refund_reason_code”: “Other”
}
],
“allocations”: ,
“billing_address”: {
“first_name”: “Test”,
“last_name”: “Pm1”,
“line1”: “5555 Cleveland Ave”,
“city”: “Columbus”,
“state_code”: “OH”,
“state”: “Ohio”,
“country”: “US”,
“zip”: “43231”,
“validation_status”: “not_validated”,
“object”: “billing_address”
},
“shipping_address”: {
“first_name”: “Test”,
“last_name”: “Pm1”,
“line1”: “5555 Cleveland Ave”,
“city”: “Columbus”,
“state_code”: “OH”,
“state”: “Ohio”,
“country”: “US”,
“zip”: “43231”,
“validation_status”: “not_validated”,
“object”: “shipping_address”
},
“customer_notes”: “”,
“site_details_at_creation”: {
“timezone”: “America/New_York”,
“organization_address”: {
“organization_name”: “Ahoy Insurance”,
“email”: “billing@ahoy.insure”,
“line1”: “2329 Nostrand Ave.”,
“line2”: “Suite 100”,
“city”: “Brooklyn”,
“state_code”: “NY”,
“state”: “New York”,
“country_code”: “US”,
“zip”: “11210”,
“phone”: “8552892469”,
“website”: “http://www.ahoy.insure”
}
},
“tax_origin”: {
“country”: “US”
}
}
},
“headers”: {
“date”: “Thu, 13 Jun 2024 12:02:21 GMT”,
“content-type”: “application/json;charset=utf-8”,
“content-length”: “4121”,
“connection”: “close”,
“cache-control”: “no-store, no-cache, must-revalidate”,
“expires”: “Thu, 01 Jan 1970 00:00:00 UTC”,
“strict-transport-security”: “max-age=31536000; includeSubDomains; preload”,
“pragma”: “no-cache”,
“x-content-type-options”: “nosniff”,
“vary”: “Accept-Encoding”,
“server”: “ChargeBee”
},
“statusCode”: 200
}
]

10

Welcome to the Make community!

For further assistance, please provide the following:

1. Screenshots of module fields and filters

Please share screenshots of relevant module fields and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:
Screenshot_2023-10-07_111039

2. Scenario blueprint

Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

Screenshot_2023-08-24_230826
(Note: Exporting your scenario will not include private information or keys to your connections)

Uploading it here will look like this:

blueprint.json (12.3 KB)

3. And most importantly, Output bundles

Please provide the output bundles of the modules by running the scenario, then click the white speech bubble on the top-right of each module and select “Download output bundles”.
Screenshot_2023-10-06_141025

A.

Save the bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

Uploading it here will look like this:

bundle.txt (12.3 KB)

B.

If you are unable to upload files on this forum, alternatively you can paste the formatted output bundle in this manner:

  • Either add three backticks ``` before and after the code, like this:

    ```
    input/output bundle content goes here
    ```

  • Or use the format code button in the editor:
    Screenshot_2023-10-02_191027

Providing the output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

samliew – request private consultation

Join the unofficial Make Discord server to chat with us!

1 Like