Skip to main content
POST
/
companies
/
{company_id}
/
subscriptions
/
find
Find Subscriptions
curl --request POST \
  --url https://api.maplebilling.com/api/v1/companies/{company_id}/subscriptions/find \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "pagination": {
    "from_key": "<unknown>",
    "limit": 20
  },
  "sort_key": "createdAtDesc",
  "include_meta": "<unknown>",
  "query": {
    "auto_charges": "<unknown>",
    "auto_renews": "<unknown>",
    "bundle_pricing_id": "<unknown>",
    "customer_id": "<unknown>",
    "end_date": {
      "eq": "<unknown>",
      "gte": "<unknown>",
      "lt": "<unknown>",
      "lte": "<unknown>"
    },
    "exclude_from_metrics": "<unknown>",
    "group_id": "<unknown>",
    "managed_externally": "<unknown>",
    "mrr": {
      "eq": "<unknown>",
      "gt": "<unknown>",
      "gte": "<unknown>",
      "lte": "<unknown>"
    },
    "next_invoice_date": {
      "eq": "<unknown>",
      "gte": "<unknown>",
      "lt": "<unknown>",
      "lte": "<unknown>"
    },
    "owner_id": "<string>",
    "owner_ids": {
      "condition": "AND",
      "values": [
        "<string>"
      ]
    },
    "parent_billed": "<unknown>",
    "parent_customer_id": "<string>",
    "payment_method_id": "<unknown>",
    "product_ids": {
      "condition": "AND",
      "values": [
        "<string>"
      ]
    },
    "product_pricing_id": "<unknown>",
    "product_pricing_ids": {
      "condition": "AND",
      "values": [
        "<string>"
      ]
    },
    "product_pricing_tags": {
      "condition": "AND",
      "values": [
        "<string>"
      ]
    },
    "product_tags": {
      "condition": "AND",
      "values": [
        "<string>"
      ]
    },
    "renewal_date": {
      "eq": "<unknown>",
      "gte": "<unknown>",
      "lt": "<unknown>",
      "lte": "<unknown>"
    },
    "search": "<unknown>",
    "start_date": {
      "eq": "<unknown>",
      "gte": "<unknown>",
      "lt": "<unknown>",
      "lte": "<unknown>"
    },
    "status": "ACTIVE",
    "statuses": "ACTIVE",
    "tags": {
      "condition": "AND",
      "values": [
        "<string>"
      ]
    },
    "trial": "<unknown>"
  }
}
'
{
  "pagination": {
    "from_key": "<unknown>",
    "limit": 123
  },
  "results": [
    {
      "arr": {
        "currency": "<string>",
        "value_in_cents": 123
      },
      "auto_charges": true,
      "auto_renews": true,
      "billing_anchor_date": "2023-11-07T05:31:56Z",
      "cancel_config": {
        "campaign_id": "<string>",
        "campaign_step_id": "<string>",
        "charge_remaining_balance": "<unknown>",
        "custom_end_date": "<unknown>",
        "custom_refund_amount": {
          "currency": "<string>",
          "value_in_cents": 123
        },
        "reason": "<unknown>",
        "refund_type": "<string>",
        "send_customer_receipt": "<unknown>",
        "timing": "<string>"
      },
      "cancel_date": "<unknown>",
      "change_config": {
        "proration_type": "NEXT",
        "timing": "IMMEDIATE",
        "actual_change_time": "<unknown>",
        "auto_charges": "<unknown>",
        "bundle_pricing": {
          "bundle_product_pricings": [
            {
              "bundle_pricing_id": "<string>",
              "company_id": "<string>",
              "created_at": "2023-11-07T05:31:56Z",
              "deleted_at": {},
              "id": "<string>",
              "product_id": "<string>",
              "product_pricing_id": "<string>",
              "updated_at": "2023-11-07T05:31:56Z"
            }
          ],
          "company_id": "<string>",
          "created_at": "2023-11-07T05:31:56Z",
          "currency": "<string>",
          "default_term": {
            "count": 123,
            "frequency": "HOUR"
          },
          "deleted_at": {},
          "description": "<string>",
          "id": "<string>",
          "image_url": "<string>",
          "import_created_at_ref": "<unknown>",
          "import_ref": "<unknown>",
          "imported_from": "<unknown>",
          "is_auto_generated": true,
          "key": "<string>",
          "metadata": {},
          "name": "<string>",
          "num_subs": 1,
          "state": "<string>",
          "updated_at": "2023-11-07T05:31:56Z"
        },
        "bundle_pricing_id": "<unknown>",
        "config_items": [
          {
            "hide_at_checkout": "<unknown>",
            "minimum_units": 1,
            "num_licenses": 1,
            "product_metric_pricing_id": "<unknown>",
            "product_pricing_id": "<unknown>",
            "quantity_config": {
              "allow_custom_quantity": true,
              "max_quantity": 123,
              "min_quantity": 123
            },
            "sort_order": "<unknown>",
            "upsell_product_metric_pricing_id": "<unknown>"
          }
        ],
        "custom_change_date": "<unknown>",
        "discounts": "<unknown>",
        "metadata": {},
        "minimum_spend": {
          "currency": "<string>",
          "value_in_cents": 123
        },
        "onetime_items": [
          {
            "aggregate": 123,
            "custom_price": {
              "amount": {
                "currency": "<string>",
                "value_in_cents": 123
              },
              "product_id": "<string>",
              "description": "<string>"
            },
            "product_pricing_id": "<unknown>",
            "quantity_config": {
              "allow_custom_quantity": true,
              "max_quantity": 123,
              "min_quantity": 123
            },
            "sort_order": "<unknown>"
          }
        ],
        "payment_method_id": "<unknown>",
        "product_pricing_ids": [
          "<string>"
        ],
        "relative_term": {
          "count": 123,
          "frequency": "HOUR"
        },
        "reset_billing_anchor": "<unknown>",
        "term": {
          "count": 123,
          "frequency": "HOUR"
        },
        "trial": "<unknown>",
        "trial_term": {
          "count": 123,
          "frequency": "HOUR"
        }
      },
      "change_date": "<unknown>",
      "company_id": "<string>",
      "computed_entitlements": [
        {
          "entitlement_id": "<string>",
          "id": "<string>",
          "inherited_from_id": "<unknown>",
          "inherited_from_type": "<unknown>",
          "key": "<string>",
          "name": "<string>",
          "original_value": "<unknown>",
          "overridden": "<unknown>",
          "type": "<string>",
          "value": "<unknown>"
        }
      ],
      "config_items": [
        {
          "hide_at_checkout": "<unknown>",
          "minimum_units": 1,
          "num_licenses": 1,
          "product_metric_pricing_id": "<unknown>",
          "product_pricing_id": "<unknown>",
          "quantity_config": {
            "allow_custom_quantity": true,
            "max_quantity": 123,
            "min_quantity": 123
          },
          "sort_order": "<unknown>",
          "upsell_product_metric_pricing_id": "<unknown>"
        }
      ],
      "created_at": "2023-11-07T05:31:56Z",
      "customer": {
        "address": {
          "address_line_1": "<string>",
          "address_line_2": "<string>",
          "city": "<string>",
          "country": "<string>",
          "place_id": "<unknown>",
          "state": "<string>",
          "zip": "<string>"
        },
        "arr": {
          "currency": "<string>",
          "value_in_cents": 123
        },
        "billing_emails": [
          "<string>"
        ],
        "company_id": "<string>",
        "computed_entitlements": [
          {
            "entitlement_id": "<string>",
            "id": "<string>",
            "inherited_from_id": "<unknown>",
            "inherited_from_type": "<unknown>",
            "key": "<string>",
            "name": "<string>",
            "original_value": "<unknown>",
            "overridden": "<unknown>",
            "type": "<string>",
            "value": "<unknown>"
          }
        ],
        "created_at": "2023-11-07T05:31:56Z",
        "customer_integration_metadata": {},
        "email": "<string>",
        "exclude_from_metrics": true,
        "id": "<string>",
        "identifier": "<string>",
        "integration_references": [
          {
            "integration_icon": "<string>",
            "integration_id": "<string>",
            "integration_key": "<string>",
            "integration_name": "<string>",
            "reference_type": "<string>",
            "remote_id": "<string>",
            "remote_type": "<string>"
          }
        ],
        "locale": "<string>",
        "managed_externally": true,
        "metadata": {},
        "mrr": {
          "currency": "<string>",
          "value_in_cents": 123
        },
        "name": "<string>",
        "org_name": "<string>",
        "owner_id": "<unknown>",
        "parent_customer_id": "<unknown>",
        "phone": "<string>",
        "status": "<string>",
        "title": "<string>",
        "updated_at": "2023-11-07T05:31:56Z"
      },
      "customer_id": "<string>",
      "end_date": "<unknown>",
      "id": "<string>",
      "invoice_additional_display_fields": [
        {
          "name": "<string>",
          "value": "<string>"
        }
      ],
      "invoice_due_date_from_creation": 1,
      "metadata": {},
      "minimum_spend": {
        "currency": "<string>",
        "value_in_cents": 123
      },
      "mrr": {
        "currency": "<string>",
        "value_in_cents": 123
      },
      "next_invoice_date": "<unknown>",
      "override_entitlements": [
        {
          "entitlement_id": "<string>",
          "id": "<string>",
          "inherited_from_id": "<unknown>",
          "inherited_from_type": "<unknown>",
          "key": "<string>",
          "name": "<string>",
          "original_value": "<unknown>",
          "overridden": "<unknown>",
          "type": "<string>",
          "value": "<unknown>"
        }
      ],
      "pause_config": {
        "behavior": "<string>",
        "resume_date": "<unknown>"
      },
      "pause_date": "<unknown>",
      "payment_method_id": "<unknown>",
      "product_pricing_ids": [
        "<string>"
      ],
      "product_pricings": [
        {
          "created_at": "2023-11-07T05:31:56Z",
          "currency": "<string>",
          "external_name": "<string>",
          "id": "<string>",
          "name": "<string>",
          "product": {
            "company_id": "<string>",
            "created_at": "2023-11-07T05:31:56Z",
            "description": "<string>",
            "entitlements": [
              {
                "entitlement_id": "<string>",
                "id": "<string>",
                "inherited_from_id": "<unknown>",
                "inherited_from_type": "<unknown>",
                "key": "<string>",
                "name": "<string>",
                "original_value": "<unknown>",
                "overridden": "<unknown>",
                "type": "<string>",
                "value": "<unknown>"
              }
            ],
            "external_name": "<string>",
            "id": "<string>",
            "image_url": "<unknown>",
            "import_created_at_ref": "<unknown>",
            "import_ref": "<unknown>",
            "imported_from": "<unknown>",
            "metadata": {},
            "name": "<string>",
            "product_pricings": [
              {
                "company_id": "<string>",
                "computed_entitlements": [
                  {
                    "entitlement_id": "<string>",
                    "id": "<string>",
                    "inherited_from_id": "<unknown>",
                    "inherited_from_type": "<unknown>",
                    "key": "<string>",
                    "name": "<string>",
                    "original_value": "<unknown>",
                    "overridden": "<unknown>",
                    "type": "<string>",
                    "value": "<unknown>"
                  }
                ],
                "created_at": "2023-11-07T05:31:56Z",
                "currency": "<string>",
                "description": "<string>",
                "external_name": "<string>",
                "id": "<string>",
                "import_created_at_ref": "<unknown>",
                "import_ref": "<unknown>",
                "imported_from": "<unknown>",
                "metadata": {},
                "name": "<string>",
                "num_subs": 1,
                "override_entitlements": [
                  {
                    "entitlement_id": "<string>",
                    "id": "<string>",
                    "inherited_from_id": "<unknown>",
                    "inherited_from_type": "<unknown>",
                    "key": "<string>",
                    "name": "<string>",
                    "original_value": "<unknown>",
                    "overridden": "<unknown>",
                    "type": "<string>",
                    "value": "<unknown>"
                  }
                ],
                "product": "<unknown>",
                "product_id": "<string>",
                "product_metric_pricings": [
                  {
                    "company_id": "<string>",
                    "created_at": "2023-11-07T05:31:56Z",
                    "id": "<string>",
                    "item": {
                      "company_id": "<string>",
                      "created_at": "2023-11-07T05:31:56Z",
                      "description": "<string>",
                      "display_type": "<string>",
                      "editable": true,
                      "external_name": "<string>",
                      "id": "<string>",
                      "name": "<string>",
                      "standard": true,
                      "type": "<string>",
                      "updated_at": "2023-11-07T05:31:56Z"
                    },
                    "item_id": "<string>",
                    "item_pricing": {
                      "base_price": {
                        "currency": "<string>",
                        "value_in_cents": 123
                      },
                      "base_units": 123,
                      "carry_over": true,
                      "charge_type": "<string>",
                      "company": {
                        "address": {
                          "address_line_1": "<string>",
                          "address_line_2": "<string>",
                          "city": "<string>",
                          "country": "<string>",
                          "place_id": "<unknown>",
                          "state": "<string>",
                          "zip": "<string>"
                        },
                        "computed_entitlements": {},
                        "created_at": "2023-11-07T05:31:56Z",
                        "customer_id": "<unknown>",
                        "demo": true,
                        "email": "<string>",
                        "id": "<string>",
                        "is_dev": true,
                        "legal_name": "<string>",
                        "name": "<string>",
                        "phone": "<string>",
                        "preferred_currency": "<string>",
                        "preferred_timezone": "<string>",
                        "slug": "<string>",
                        "updated_at": "2023-11-07T05:31:56Z"
                      },
                      "company_id": "<string>",
                      "created_at": "2023-11-07T05:31:56Z",
                      "credit_price": {
                        "type": "AMOUNT",
                        "amount": {
                          "currency": "<string>",
                          "value_in_cents": 123
                        },
                        "item_id": "<unknown>",
                        "units": 123
                      },
                      "custom_price": {
                        "max_price_per_unit": 123,
                        "min_price_per_unit": 123,
                        "preset_price_per_unit": 123,
                        "price_per_unit": 123
                      },
                      "description": "<string>",
                      "display_type": "<string>",
                      "editable": true,
                      "external_name": "<string>",
                      "fixed_price": {
                        "price_per_unit": 123
                      },
                      "frequency": "<string>",
                      "gradient_price": [
                        {
                          "end": 1,
                          "flat_price": 123,
                          "is_custom_tier": true,
                          "price_per_unit": 123,
                          "start": 1
                        }
                      ],
                      "id": "<string>",
                      "item": {
                        "company_id": "<string>",
                        "created_at": "2023-11-07T05:31:56Z",
                        "description": "<string>",
                        "display_type": "<string>",
                        "editable": true,
                        "external_name": "<string>",
                        "id": "<string>",
                        "name": "<string>",
                        "standard": true,
                        "type": "<string>",
                        "updated_at": "2023-11-07T05:31:56Z"
                      },
                      "item_id": "<string>",
                      "metadata": {},
                      "minimum_spend": {
                        "currency": "<string>",
                        "value_in_cents": 123
                      },
                      "minimum_spend_schedule": {
                        "allow_pulling_forward": true,
                        "amount_per_period": "<unknown>",
                        "minimum_spend_schedule_type": "<string>"
                      },
                      "name": "<string>",
                      "num_subs": 1,
                      "proration_type": "<string>",
                      "recognition_schedule": {
                        "amount_per_period": "<unknown>",
                        "recognition_schedule_type": "<string>"
                      },
                      "scheduled_price": {
                        "price_per_unit_per_period": [
                          "<string>"
                        ]
                      },
                      "state": "<string>",
                      "step_price": {
                        "price_per_step": 123,
                        "step_size": 1
                      },
                      "term_count": 123,
                      "true_up_frequency": "<string>",
                      "type": "<string>",
                      "updated_at": "2023-11-07T05:31:56Z",
                      "volume_price": [
                        {
                          "flat_price": 123,
                          "is_custom_tier": true,
                          "price_per_unit": 123,
                          "total_units_end": 1,
                          "total_units_start": 1
                        }
                      ]
                    },
                    "item_pricing_id": "<string>",
                    "metric": {
                      "company_id": "<string>",
                      "created_at": "2023-11-07T05:31:56Z",
                      "description": "<string>",
                      "external_name": "<string>",
                      "id": "<string>",
                      "item_id": "<string>",
                      "metering_rule": {
                        "aggregator": "<string>",
                        "group_keys": [
                          "<string>"
                        ],
                        "property": "<string>",
                        "rule": "<unknown>"
                      },
                      "name": "<string>",
                      "standard": true,
                      "type": "<string>",
                      "updated_at": "2023-11-07T05:31:56Z"
                    },
                    "metric_id": "<string>",
                    "product_id": "<string>",
                    "updated_at": "2023-11-07T05:31:56Z"
                  }
                ],
                "state": "<string>",
                "tags": [
                  "<string>"
                ],
                "type": "<string>",
                "updated_at": "2023-11-07T05:31:56Z",
                "upsell_product_pricing_id": "<unknown>"
              }
            ],
            "state": "<string>",
            "tags": [
              "<string>"
            ],
            "updated_at": "2023-11-07T05:31:56Z"
          },
          "product_id": "<string>",
          "product_metric_pricings": [
            {
              "created_at": "2023-11-07T05:31:56Z",
              "id": "<string>",
              "item": {
                "company_id": "<string>",
                "created_at": "2023-11-07T05:31:56Z",
                "description": "<string>",
                "display_type": "<string>",
                "editable": true,
                "external_name": "<string>",
                "id": "<string>",
                "name": "<string>",
                "standard": true,
                "type": "<string>",
                "updated_at": "2023-11-07T05:31:56Z"
              },
              "item_id": "<string>",
              "item_pricing": {
                "base_price": {
                  "currency": "<string>",
                  "value_in_cents": 123
                },
                "base_units": 123,
                "carry_over": true,
                "charge_type": "<string>",
                "company": {
                  "address": {
                    "address_line_1": "<string>",
                    "address_line_2": "<string>",
                    "city": "<string>",
                    "country": "<string>",
                    "place_id": "<unknown>",
                    "state": "<string>",
                    "zip": "<string>"
                  },
                  "computed_entitlements": {},
                  "created_at": "2023-11-07T05:31:56Z",
                  "customer_id": "<unknown>",
                  "demo": true,
                  "email": "<string>",
                  "id": "<string>",
                  "is_dev": true,
                  "legal_name": "<string>",
                  "name": "<string>",
                  "phone": "<string>",
                  "preferred_currency": "<string>",
                  "preferred_timezone": "<string>",
                  "slug": "<string>",
                  "updated_at": "2023-11-07T05:31:56Z"
                },
                "company_id": "<string>",
                "created_at": "2023-11-07T05:31:56Z",
                "credit_price": {
                  "type": "AMOUNT",
                  "amount": {
                    "currency": "<string>",
                    "value_in_cents": 123
                  },
                  "item_id": "<unknown>",
                  "units": 123
                },
                "custom_price": {
                  "max_price_per_unit": 123,
                  "min_price_per_unit": 123,
                  "preset_price_per_unit": 123,
                  "price_per_unit": 123
                },
                "description": "<string>",
                "display_type": "<string>",
                "editable": true,
                "external_name": "<string>",
                "fixed_price": {
                  "price_per_unit": 123
                },
                "frequency": "<string>",
                "gradient_price": [
                  {
                    "end": 1,
                    "flat_price": 123,
                    "is_custom_tier": true,
                    "price_per_unit": 123,
                    "start": 1
                  }
                ],
                "id": "<string>",
                "item": {
                  "company_id": "<string>",
                  "created_at": "2023-11-07T05:31:56Z",
                  "description": "<string>",
                  "display_type": "<string>",
                  "editable": true,
                  "external_name": "<string>",
                  "id": "<string>",
                  "name": "<string>",
                  "standard": true,
                  "type": "<string>",
                  "updated_at": "2023-11-07T05:31:56Z"
                },
                "item_id": "<string>",
                "metadata": {},
                "minimum_spend": {
                  "currency": "<string>",
                  "value_in_cents": 123
                },
                "minimum_spend_schedule": {
                  "allow_pulling_forward": true,
                  "amount_per_period": "<unknown>",
                  "minimum_spend_schedule_type": "<string>"
                },
                "name": "<string>",
                "num_subs": 1,
                "proration_type": "<string>",
                "recognition_schedule": {
                  "amount_per_period": "<unknown>",
                  "recognition_schedule_type": "<string>"
                },
                "scheduled_price": {
                  "price_per_unit_per_period": [
                    "<string>"
                  ]
                },
                "state": "<string>",
                "step_price": {
                  "price_per_step": 123,
                  "step_size": 1
                },
                "term_count": 123,
                "true_up_frequency": "<string>",
                "type": "<string>",
                "updated_at": "2023-11-07T05:31:56Z",
                "volume_price": [
                  {
                    "flat_price": 123,
                    "is_custom_tier": true,
                    "price_per_unit": 123,
                    "total_units_end": 1,
                    "total_units_start": 1
                  }
                ]
              },
              "item_pricing_id": "<string>",
              "metric": {
                "company_id": "<string>",
                "created_at": "2023-11-07T05:31:56Z",
                "description": "<string>",
                "external_name": "<string>",
                "id": "<string>",
                "item_id": "<string>",
                "metering_rule": {
                  "aggregator": "<string>",
                  "group_keys": [
                    "<string>"
                  ],
                  "property": "<string>",
                  "rule": "<unknown>"
                },
                "name": "<string>",
                "standard": true,
                "type": "<string>",
                "updated_at": "2023-11-07T05:31:56Z"
              },
              "metric_id": "<string>",
              "minimum_units": 123,
              "num_licenses": 123,
              "updated_at": "2023-11-07T05:31:56Z"
            }
          ],
          "tags": [
            "<string>"
          ],
          "type": "<string>",
          "updated_at": "2023-11-07T05:31:56Z"
        }
      ],
      "renewal_date": "<unknown>",
      "start_date": "2023-11-07T05:31:56Z",
      "status": "<string>",
      "term": {
        "count": 123,
        "frequency": "HOUR"
      },
      "trial": true,
      "trial_conversion_date": "<unknown>",
      "updated_at": "2023-11-07T05:31:56Z"
    }
  ]
}

Authorizations

Authorization
string
header
required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Headers

Idempotency-Key
string

The idempotency key that will be used to ensure the request is only performed once

Path Parameters

company_id
string
required

The company ID with the prefix 'cmp_'.

Body

application/json
pagination
object
required

The pagination parameters for the request

sort_key
enum<string>
default:createdAtDesc
required
Available options:
createdAtDesc,
createdAtAsc,
updatedAtAsc,
updatedAtDesc,
mrrAsc,
mrrDesc,
startDateAsc,
startDateDesc,
nextInvoiceAsc,
nextInvoiceDesc,
renewalDateAsc,
renewalDateDesc
include_meta
null | boolean

Whether to include additional metadata in the pagination response such the number of total results

query
object

The query criteria for the request

Response

200 - application/json

OK

pagination
object
results
object[] | null