Error
orderListWhere: { "$and": [ { "$eq": { "IsDeleted": false } }, { "$eq": { "MemberId": "2676798" } } ] }ItemList : {}
orders component: { "Items": [ { "CustomerEmail": "testt3606@gmail.com", "CustomerEmailToLower": "testt3606@gmail.com", "PaymentType": null, "State": "Paid", "Name": "Marketplace 9257-#2 New company test", "NameToLower": "marketplace 9257-#2 new company test", "InvoiceNumber": 180810, "InvoiceNumberToLower": "180810", "AmountPaid": 24.7000, "InvoiceCode": null, "InvoiceCodeToLower": null, "InvoiceDate": "2025-12-08T06:58:05.639104", "AWBNumber": null, "TrackingURL": null, "OrderState": "Paid", "IsRecurring": false, "HasActiveSubscription": false, "PaymentIntentId": null, "PaymentIntentClientSecret": null, "SubTotalPrice": 24.7000, "TaxRate": 0.0, "DiscountPrice": 0.0000, "TotalPrice": 24.7000, "GiftVoucherPrice": 0.0000, "TaxCode": null, "TaxPrice": 0.0000, "AddressLine": "test", "ShippingCity": "test", "ShippingState": "AL", "ShippingZipCode": "92181", "ShippingCountry": "UNITED STATES", "AmountPending": 0.0000, "FormId": "0", "MemberId": "2676798", "CaseId": "0", "MainOrderId": null, "ShippingAddress": { "AddressLine": "test", "City": "test", "State": "AL", "ZipCode": "92181", "Country": "UNITED STATES" }, "AmountPaidHtml": "$24.70", "AmountPendingHtml": "$0.00", "Id": "10648539", "TaxPercent": 0.0, "ShippingPrice": 0.0000, "ShippingTaxRate": 0.0, "ShippingTaxPrice": 0.00, "ShippingSubTotalPrice": 0.00, "ShippingTotalPrice": 0.00, "SubTotalTaxPrice": 0.00000000, "DiscountedSubTotalTaxPrice": 0.00000000, "GrandTotalPrice": 24.70000000, "TotalPriceExcludingTax": 24.7000, "TotalPriceExcludingTaxAndGiftVoucherAmount": 24.7000, "DiscountPriceExcludingTax": 0.0000, "ShippingOption": { "Id": "10648537", "ShippingOptionId": "0", "Name": null, "Price": 0.0000, "TaxPercent": 0.0, "TaxRate": 0.0, "TaxPrice": 0.00, "TotalPrice": 0.00, "SubTotalPrice": 0.00 }, "FormatSetting": { "Id": "556622", "Name": "Default", "Culture": "en-US", "DecimalsQuantity": 2, "Currency": { "Code": "USD", "Symbol": "$", "DigitalCode": "840", "Name": "US Dollar" } }, "DomainCountry": { "Name": "UNITED STATES", "Code": "US" }, "DestinationCountry": { "Name": "UNITED STATES", "Code": "US" }, "Discount": null, "GiftVoucher": null, "TotalPriceExcludingTaxHtml": "$24.70", "TotalPriceExcludingTaxAndGiftVoucherAmountHtml": "$24.70", "GrandTotalPriceHtml": "$24.70", "DiscountPriceHtml": "$0.00", "DiscountedSubTotalTaxPriceHtml": "$0.00", "SubTotalTaxPriceHtml": "$0.00", "TaxPriceHtml": "$0.00", "ShippingTotalPriceHtml": "$0.00", "ShippingPriceHtml": "$0.00", "ShippingTaxPriceHtml": "$0.00", "ShippingTaxPercentHtml": "0%", "TaxPercentHtml": "0%", "GiftVoucherPriceHtml": "$0.00", "TotalPriceHtml": "$24.70", "Items": [ { "EcommerceItemId": 8418, "SmallImage": null, "Name": "[Surcharge]", "SKUCode": "74b07a62-2582-4f9e-98d4-373891028de5", "Quantity": 1, "ModuleItemUrl": "/catalogs/mn-marketplace-not-member-surcharge", "TaxCode": null, "OnSale": false, "Price": 0.0000, "TaxRate": 0.0000, "UnitPrice": 0.7000, "RecommendedPrice": 0.0000, "IsDownloadable": false, "WebDomain": "dev-mammothnation.treepl.co", "Attributes": [], "Id": "10648560", "ProductFileLink": "", "Url": "/catalogs/mn-marketplace-not-member-surcharge", "TaxPercent": 0.0000, "TaxPrice": 0.00000000, "TotalPrice": 0.70000000, "UnitTaxPrice": 0.00000000, "UnitTotalPrice": 0.70000000, "UnitRecommendedTaxPrice": 0.00000000, "UnitRecommendedTotalPrice": 0.00000000, "UnitRecommendedPrice": 0.0000, "TotalPriceExcludingTax": 0.7000, "TaxPercentHtml": "0%", "TotalPriceExcludingTaxHtml": "$0.70", "UnitTaxPriceHtml": "$0.00", "UnitTotalPriceHtml": "$0.70", "UnitPriceHtmlTotal": "$0.70", "PriceHtml": "$0.00", "UnitPriceHtml": "$0.70", "TaxPriceHtml": "$0.00", "TotalPriceHtml": "$0.70", "QuantityHtml": "", "RemoveHtml": "", "TaxCodeHtml": "", "UnitRecommendedPriceHtml": "$0.00", "UnitRecommendedTaxPriceHtml": "$0.00", "UnitRecommendedTotalPriceHtml": "$0.00" }, { "EcommerceItemId": 8414, "SmallImage": null, "Name": "[SHIP] Flat rate", "SKUCode": "f87bd89e-116e-4dec-a465-88c91b1bec60", "Quantity": 1, "ModuleItemUrl": "/catalogs/mn-marketplace-shipping", "TaxCode": null, "OnSale": false, "Price": 0.0000, "TaxRate": 0.0000, "UnitPrice": 10.0000, "RecommendedPrice": 0.0000, "IsDownloadable": false, "WebDomain": "dev-mammothnation.treepl.co", "Attributes": [], "Id": "10648562", "ProductFileLink": "", "Url": "/catalogs/mn-marketplace-shipping", "TaxPercent": 0.0000, "TaxPrice": 0.00000000, "TotalPrice": 10.00000000, "UnitTaxPrice": 0.00000000, "UnitTotalPrice": 10.00000000, "UnitRecommendedTaxPrice": 0.00000000, "UnitRecommendedTotalPrice": 0.00000000, "UnitRecommendedPrice": 0.0000, "TotalPriceExcludingTax": 10.0000, "TaxPercentHtml": "0%", "TotalPriceExcludingTaxHtml": "$10.00", "UnitTaxPriceHtml": "$0.00", "UnitTotalPriceHtml": "$10.00", "UnitPriceHtmlTotal": "$10.00", "PriceHtml": "$0.00", "UnitPriceHtml": "$10.00", "TaxPriceHtml": "$0.00", "TotalPriceHtml": "$10.00", "QuantityHtml": "", "RemoveHtml": "", "TaxCodeHtml": "", "UnitRecommendedPriceHtml": "$0.00", "UnitRecommendedTaxPriceHtml": "$0.00", "UnitRecommendedTotalPriceHtml": "$0.00" }, { "EcommerceItemId": 8416, "SmallImage": null, "Name": "[PRODUCTS]", "SKUCode": "1d9bfc0b-7a15-4f7b-9401-0066d0cede5c", "Quantity": 1, "ModuleItemUrl": "/catalogs/mn-marketplace-product", "TaxCode": null, "OnSale": false, "Price": 0.0000, "TaxRate": 0.0000, "UnitPrice": 14.0000, "RecommendedPrice": 0.0000, "IsDownloadable": false, "WebDomain": "dev-mammothnation.treepl.co", "Attributes": [], "Id": "10648564", "ProductFileLink": "", "Url": "/catalogs/mn-marketplace-product", "TaxPercent": 0.0000, "TaxPrice": 0.00000000, "TotalPrice": 14.00000000, "UnitTaxPrice": 0.00000000, "UnitTotalPrice": 14.00000000, "UnitRecommendedTaxPrice": 0.00000000, "UnitRecommendedTotalPrice": 0.00000000, "UnitRecommendedPrice": 0.0000, "TotalPriceExcludingTax": 14.0000, "TaxPercentHtml": "0%", "TotalPriceExcludingTaxHtml": "$14.00", "UnitTaxPriceHtml": "$0.00", "UnitTotalPriceHtml": "$14.00", "UnitPriceHtmlTotal": "$14.00", "PriceHtml": "$0.00", "UnitPriceHtml": "$14.00", "TaxPriceHtml": "$0.00", "TotalPriceHtml": "$14.00", "QuantityHtml": "", "RemoveHtml": "", "TaxCodeHtml": "", "UnitRecommendedPriceHtml": "$0.00", "UnitRecommendedTaxPriceHtml": "$0.00", "UnitRecommendedTotalPriceHtml": "$0.00" } ], "SubTotalPriceHtml": "$24.70", "TaxCodeHtml": "", "Params": {} } ], "Params": { "viewtype": "list", "currentmemberonly": "false", "filterby": "MemberId", "filtervalue": "2676798", "limit": "1", "type": "orders", "layout": "", "collectionvariable": "ggg" } }
Success
orderListWhere: { "$and": [ { "$eq": { "IsDeleted": false } }, { "$eq": { "MemberId": "3111061" } } ] }ItemList : {}
orders component: { "Items": [ { "CustomerEmail": "nhaney0@outlook.com", "CustomerEmailToLower": "nhaney0@outlook.com", "PaymentType": "CreditCard", "State": "Paid", "Name": "Lifetime Membership", "NameToLower": "lifetime membership", "InvoiceNumber": 52633, "InvoiceNumberToLower": "52633", "AmountPaid": 299.0000, "InvoiceCode": null, "InvoiceCodeToLower": null, "InvoiceDate": "2022-02-17T10:41:27.094443", "AWBNumber": null, "TrackingURL": null, "OrderState": "Paid", "IsRecurring": false, "HasActiveSubscription": false, "PaymentIntentId": "pi_3KUC6iDXonPN6eJb2eOq13C6", "PaymentIntentClientSecret": "pi_3KUC6iDXonPN6eJb2eOq13C6_secret_JSurL9VCWNmnQ1OCPOjLgcfqs", "SubTotalPrice": 299.0000, "TaxRate": 0.0, "DiscountPrice": 0.0000, "TotalPrice": 299.0000, "GiftVoucherPrice": 0.0000, "TaxCode": null, "TaxPrice": 0.0000, "AddressLine": null, "ShippingCity": null, "ShippingState": null, "ShippingZipCode": null, "ShippingCountry": null, "AmountPending": 0.0000, "FormId": "81504", "MemberId": "3111061", "CaseId": "3112609", "MainOrderId": null, "ShippingAddress": { "AddressLine": null, "City": null, "State": null, "ZipCode": null, "Country": null }, "AmountPaidHtml": "$299.00", "AmountPendingHtml": "$0.00", "Id": "3112625", "TaxPercent": 0.0, "ShippingPrice": 0.0000, "ShippingTaxRate": 0.0, "ShippingTaxPrice": 0.00, "ShippingSubTotalPrice": 0.00, "ShippingTotalPrice": 0.00, "SubTotalTaxPrice": 0.00000000, "DiscountedSubTotalTaxPrice": 0.00000000, "GrandTotalPrice": 299.00000000, "TotalPriceExcludingTax": 299.0000, "TotalPriceExcludingTaxAndGiftVoucherAmount": 299.0000, "DiscountPriceExcludingTax": 0.0000, "ShippingOption": { "Id": "3112624", "ShippingOptionId": "0", "Name": null, "Price": 0.0000, "TaxPercent": 0.0, "TaxRate": 0.0, "TaxPrice": 0.00, "TotalPrice": 0.00, "SubTotalPrice": 0.00 }, "FormatSetting": { "Id": "556622", "Name": "Default", "Culture": "en-US", "DecimalsQuantity": 2, "Currency": { "Code": "USD", "Symbol": "$", "DigitalCode": "840", "Name": "US Dollar" } }, "DomainCountry": { "Name": "UNITED STATES", "Code": "US" }, "DestinationCountry": { "Name": null, "Code": null }, "Discount": null, "GiftVoucher": null, "TotalPriceExcludingTaxHtml": "$299.00", "TotalPriceExcludingTaxAndGiftVoucherAmountHtml": "$299.00", "GrandTotalPriceHtml": "$299.00", "DiscountPriceHtml": "$0.00", "DiscountedSubTotalTaxPriceHtml": "$0.00", "SubTotalTaxPriceHtml": "$0.00", "TaxPriceHtml": "$0.00", "ShippingTotalPriceHtml": "$0.00", "ShippingPriceHtml": "$0.00", "ShippingTaxPriceHtml": "$0.00", "ShippingTaxPercentHtml": "0%", "TaxPercentHtml": "0%", "GiftVoucherPriceHtml": "$0.00", "TotalPriceHtml": "$299.00", "Items": [ { "EcommerceItemId": 0, "SmallImage": null, "Name": "Lifetime Membership", "SKUCode": "Lifetime Membership", "Quantity": 1, "ModuleItemUrl": null, "TaxCode": null, "OnSale": false, "Price": 299.0000, "TaxRate": 0.0000, "UnitPrice": 299.0000, "RecommendedPrice": 0.0000, "IsDownloadable": false, "WebDomain": "mammothnation.com", "Attributes": [], "Id": "3112606", "ProductFileLink": "", "Url": null, "TaxPercent": 0.0000, "TaxPrice": 0.00000000, "TotalPrice": 299.00000000, "UnitTaxPrice": 0.00000000, "UnitTotalPrice": 299.00000000, "UnitRecommendedTaxPrice": 0.00000000, "UnitRecommendedTotalPrice": 0.00000000, "UnitRecommendedPrice": 0.0000, "TotalPriceExcludingTax": 299.0000, "TaxPercentHtml": "0%", "TotalPriceExcludingTaxHtml": "$299.00", "UnitTaxPriceHtml": "$0.00", "UnitTotalPriceHtml": "$299.00", "UnitPriceHtmlTotal": "$299.00", "PriceHtml": "$299.00", "UnitPriceHtml": "$299.00", "TaxPriceHtml": "$0.00", "TotalPriceHtml": "$299.00", "QuantityHtml": "", "RemoveHtml": "", "TaxCodeHtml": "", "UnitRecommendedPriceHtml": "$0.00", "UnitRecommendedTaxPriceHtml": "$0.00", "UnitRecommendedTotalPriceHtml": "$0.00" } ], "SubTotalPriceHtml": "$299.00", "TaxCodeHtml": "", "Params": {} } ], "Params": { "viewtype": "list", "currentmemberonly": "false", "filterby": "MemberId", "filtervalue": "3111061", "limit": "1", "type": "orders", "layout": "", "collectionvariable": "ggg" } }