steampipe plugin install francois2metz/scalingosteampipe plugin install francois2metz/scalingo

Table: scalingo_invoice

List the invoices associated to your account.

Examples

List invoices

select
  id,
  total_price
from
  scalingo_invoice;

Get unpaid invoices

select
  id,
  total_price
from
  scalingo_invoice
where
  state != 'paid';

Get price in € per years

select
  year,
  round(sum(total_price) / 100, 2) as total_price,
  round(sum(total_price_with_vat) / 100, 2) as total_price_with_vat
from
  (
    select
      date_part('year', billing_month) as year,
      total_price,
      total_price_with_vat
    from
      scalingo_invoice
  ) as invoices_as_year
group by
  year;

Schema for scalingo_invoice

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
billing_month	timestamp with time zone		This invoice is related to this month.
detailed_items	jsonb		Detail breakdown of the consumption.
id	text	=	Unique ID of the invoice.
invoice_number	text		The invoice number.
items	jsonb		The list of items to pay.
pdf_url	text		URL to download the PDF invoice.
state	text		The state of this invoice (new, paid or failed).
total_price	bigint		price of this invoice (cents).
total_price_with_vat	bigint		Price of this invoice including VAT (cents).
vat_rate	bigint		The VAT rate applied to this invoice (in ‰).