/fuel-pump-inventories-sales-invoices-post-one

Summary

  • Source repository: jef-systems/jef-fuel-pump-inventories-backend

  • Source SHA: 72119609d80692052adc7462ef8cbe24eb23f022

  • Source run id: 28366940754

  • Lambda function: jef-fuel-pump-inventories-post-004

  • HTTP method: POST

  • API path: /fuel-pump-inventories-sales-invoices-post-one

  • Endpoint URL: https://fsqf5slhc1.execute-api.ap-southeast-1.amazonaws.com/prod/fuel-pump-inventories-sales-invoices-post-one

  • Payload mode: json-body

Description

Function

jef-fuel-pump-inventories-post-004 Logical ID: jef-fuel-pump-inventories:jef-fuel-pump-inventories-sales-invoices:post-one Order Number: 004

Module

jef-fuel-pump-inventories

Action

post-one

Method

POST

Invocation Mode

ASYNC

Resource Path

/fuel-pump-inventories-sales-invoices-post-one Endpoint Name: jef-fuel-pump-inventories-sales-invoices-post-one

Table

jef-fuel-pump-inventories-sales-invoices

Primary Key

sales_invoice_id

API Gateway Response

status\_code

202

message

Request accepted for asynchronous processing.

Payload Example

sales\_invoice\_id

ca3647e3-e530-4038-a2f0-840c7101e468

gas\_station\_id

3fc3add0-150b-4b4e-9c0d-547815678627

invoice\_number

value-001

date

2026-05-17

shift

value-001

customer\_name

Sample Name

plate\_number

value-001

payment\_method

value-001

total\_liters

1

total\_amount

1

notes

value-001

status

value-001

created

2026-06-29T10:53:22Z

updated

2026-06-29T10:53:22Z

children.jef-fuel-pump-inventories-sales-invoice-line-items\[0\].sales\_invoice\_line\_item\_id

d9e72b30-082a-4891-9606-5bda1bc5eccd

children.jef-fuel-pump-inventories-sales-invoice-line-items\[0\].sales\_invoice\_id

ca3647e3-e530-4038-a2f0-840c7101e468

children.jef-fuel-pump-inventories-sales-invoice-line-items\[0\].gas\_station\_id

358366d9-fed5-45c6-8d2a-1973b82b7410

children.jef-fuel-pump-inventories-sales-invoice-line-items\[0\].line\_number

1

children.jef-fuel-pump-inventories-sales-invoice-line-items\[0\].pump\_id

566e8351-2cfe-48fd-8631-8442e1c1ae45

children.jef-fuel-pump-inventories-sales-invoice-line-items\[0\].pump

value-001

children.jef-fuel-pump-inventories-sales-invoice-line-items\[0\].product

value-001

children.jef-fuel-pump-inventories-sales-invoice-line-items\[0\].liters

1

children.jef-fuel-pump-inventories-sales-invoice-line-items\[0\].price\_per\_liter

1

children.jef-fuel-pump-inventories-sales-invoice-line-items\[0\].total\_amount

1

children.jef-fuel-pump-inventories-sales-invoice-line-items\[0\].created

2026-06-29T10:53:22Z

children.jef-fuel-pump-inventories-sales-invoice-line-items\[0\].updated

2026-06-29T10:53:22Z

Payload Schema

{
  "type": "object",
  "additionalProperties": "False",
  "payload_mode": "parent-plus-children-wrapper",
  "allow_children_wrapper": "True",
  "children_wrapper_field": "children",
  "allow_batch": "False",
  "table": "jef-fuel-pump-inventories-sales-invoices",
  "primary_key": "sales_invoice_id",
  "required[0]": "gas_station_id",
  "required[1]": "invoice_number",
  "required[2]": "date",
  "required[3]": "shift",
  "required[4]": "customer_name",
  "required[5]": "payment_method",
  "required[6]": "total_liters",
  "required[7]": "total_amount",
  "required[8]": "status",
  "properties.sales_invoice_id.field": "sales_invoice_id",
  "properties.sales_invoice_id.type": "S",
  "properties.sales_invoice_id.required": "False",
  "properties.sales_invoice_id.source_required": "True",
  "properties.sales_invoice_id.server_generated": "True",
  "properties.sales_invoice_id.autogenerated": "False",
  "properties.sales_invoice_id.frontend_autocomputed": "False",
  "properties.sales_invoice_id.format": "uuidv4",
  "properties.sales_invoice_id.regex": "^[1-9a-fA-F][0-9a-fA-F]{7}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}$",
  "properties.gas_station_id.field": "gas_station_id",
  "properties.gas_station_id.type": "S",
  "properties.gas_station_id.required": "True",
  "properties.gas_station_id.source_required": "True",
  "properties.gas_station_id.server_generated": "True",
  "properties.gas_station_id.autogenerated": "False",
  "properties.gas_station_id.frontend_autocomputed": "False",
  "properties.gas_station_id.format": "uuidv4",
  "properties.gas_station_id.regex": "^[1-9a-fA-F][0-9a-fA-F]{7}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}$",
  "properties.invoice_number.field": "invoice_number",
  "properties.invoice_number.type": "S",
  "properties.invoice_number.required": "True",
  "properties.invoice_number.source_required": "True",
  "properties.invoice_number.server_generated": "False",
  "properties.invoice_number.autogenerated": "False",
  "properties.invoice_number.frontend_autocomputed": "False",
  "properties.invoice_number.regex": "^[A-Za-z0-9_-]{1,64}$",
  "properties.date.field": "date",
  "properties.date.type": "S",
  "properties.date.required": "True",
  "properties.date.source_required": "True",
  "properties.date.server_generated": "False",
  "properties.date.autogenerated": "False",
  "properties.date.frontend_autocomputed": "False",
  "properties.date.regex": "^\\d{4}-\\d{2}-\\d{2}$",
  "properties.shift.field": "shift",
  "properties.shift.type": "S",
  "properties.shift.required": "True",
  "properties.shift.source_required": "True",
  "properties.shift.server_generated": "False",
  "properties.shift.autogenerated": "False",
  "properties.shift.frontend_autocomputed": "False",
  "properties.shift.regex": "^(morning|afternoon|night)$",
  "properties.customer_name.field": "customer_name",
  "properties.customer_name.type": "S",
  "properties.customer_name.required": "True",
  "properties.customer_name.source_required": "True",
  "properties.customer_name.server_generated": "False",
  "properties.customer_name.autogenerated": "False",
  "properties.customer_name.frontend_autocomputed": "False",
  "properties.customer_name.regex": "^[A-Za-z0-9 .,'_-]{1,120}$",
  "properties.plate_number.field": "plate_number",
  "properties.plate_number.type": "S",
  "properties.plate_number.required": "False",
  "properties.plate_number.source_required": "False",
  "properties.plate_number.server_generated": "False",
  "properties.plate_number.autogenerated": "False",
  "properties.plate_number.frontend_autocomputed": "False",
  "properties.plate_number.regex": "^[A-Za-z0-9 ._-]{1,30}$",
  "properties.payment_method.field": "payment_method",
  "properties.payment_method.type": "S",
  "properties.payment_method.required": "True",
  "properties.payment_method.source_required": "True",
  "properties.payment_method.server_generated": "False",
  "properties.payment_method.autogenerated": "False",
  "properties.payment_method.frontend_autocomputed": "False",
  "properties.payment_method.regex": "^(cash|gcash|maya|credit_card|debit_card|bank_transfer|check|fleet_card|other)$",
  "properties.total_liters.field": "total_liters",
  "properties.total_liters.type": "N",
  "properties.total_liters.required": "True",
  "properties.total_liters.source_required": "True",
  "properties.total_liters.server_generated": "False",
  "properties.total_liters.autogenerated": "False",
  "properties.total_liters.frontend_autocomputed": "False",
  "properties.total_liters.regex": "^-?\\d+(\\.\\d+)?$",
  "properties.total_amount.field": "total_amount",
  "properties.total_amount.type": "N",
  "properties.total_amount.required": "True",
  "properties.total_amount.source_required": "True",
  "properties.total_amount.server_generated": "False",
  "properties.total_amount.autogenerated": "False",
  "properties.total_amount.frontend_autocomputed": "False",
  "properties.total_amount.regex": "^-?\\d+(\\.\\d+)?$",
  "properties.notes.field": "notes",
  "properties.notes.type": "S",
  "properties.notes.required": "False",
  "properties.notes.source_required": "False",
  "properties.notes.server_generated": "False",
  "properties.notes.autogenerated": "False",
  "properties.notes.frontend_autocomputed": "False",
  "properties.notes.regex": "^.{0,500}$",
  "properties.status.field": "status",
  "properties.status.type": "S",
  "properties.status.required": "True",
  "properties.status.source_required": "True",
  "properties.status.server_generated": "False",
  "properties.status.autogenerated": "False",
  "properties.status.frontend_autocomputed": "False",
  "properties.status.regex": "^(draft|submitted|approved|cancelled)$",
  "properties.created.field": "created",
  "properties.created.type": "S",
  "properties.created.required": "False",
  "properties.created.source_required": "True",
  "properties.created.server_generated": "True",
  "properties.created.autogenerated": "False",
  "properties.created.frontend_autocomputed": "False",
  "properties.created.format": "iso8601",
  "properties.created.regex": "^\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}(\\.\\d{1,6})?Z?$",
  "properties.updated.field": "updated",
  "properties.updated.type": "S",
  "properties.updated.required": "False",
  "properties.updated.source_required": "True",
  "properties.updated.server_generated": "True",
  "properties.updated.autogenerated": "False",
  "properties.updated.frontend_autocomputed": "False",
  "properties.updated.format": "iso8601",
  "properties.updated.regex": "^\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}(\\.\\d{1,6})?Z?$",
  "children[0].parent_table": "jef-fuel-pump-inventories-sales-invoices",
  "children[0].child_table": "jef-fuel-pump-inventories-sales-invoice-line-items",
  "children[0].parent_key": "sales_invoice_id",
  "children[0].child_foreign_key": "sales_invoice_id",
  "children[0].child_index_name": "gsi_1",
  "children[0].child_index_key": "gsi_1_pk",
  "children[0].aliases[0]": "jef-fuel-pump-inventories-sales-invoice-line-items",
  "children[0].aliases[1]": "sales-invoice-line-items",
  "children[0].aliases[2]": "fuel-pump-inventories-sales-invoice-line-items",
  "children[0].aliases[3]": "jef_fuel_pump_inventories_sales_invoice_line_items",
  "children[0].aliases[4]": "sales_invoice_line_items",
  "children[0].aliases[5]": "fuel_pump_inventories_sales_invoice_line_items",
  "children[0].aliases[6]": "items",
  "root.type": "object",
  "root.attributes.sales_invoice_id.field": "sales_invoice_id",
  "root.attributes.sales_invoice_id.type": "S",
  "root.attributes.sales_invoice_id.required": "False",
  "root.attributes.sales_invoice_id.source_required": "True",
  "root.attributes.sales_invoice_id.server_generated": "True",
  "root.attributes.sales_invoice_id.autogenerated": "False",
  "root.attributes.sales_invoice_id.frontend_autocomputed": "False",
  "root.attributes.sales_invoice_id.format": "uuidv4",
  "root.attributes.sales_invoice_id.regex": "^[1-9a-fA-F][0-9a-fA-F]{7}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}$",
  "root.attributes.gas_station_id.field": "gas_station_id",
  "root.attributes.gas_station_id.type": "S",
  "root.attributes.gas_station_id.required": "True",
  "root.attributes.gas_station_id.source_required": "True",
  "root.attributes.gas_station_id.server_generated": "True",
  "root.attributes.gas_station_id.autogenerated": "False",
  "root.attributes.gas_station_id.frontend_autocomputed": "False",
  "root.attributes.gas_station_id.format": "uuidv4",
  "root.attributes.gas_station_id.regex": "^[1-9a-fA-F][0-9a-fA-F]{7}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}$",
  "root.attributes.invoice_number.field": "invoice_number",
  "root.attributes.invoice_number.type": "S",
  "root.attributes.invoice_number.required": "True",
  "root.attributes.invoice_number.source_required": "True",
  "root.attributes.invoice_number.server_generated": "False",
  "root.attributes.invoice_number.autogenerated": "False",
  "root.attributes.invoice_number.frontend_autocomputed": "False",
  "root.attributes.invoice_number.regex": "^[A-Za-z0-9_-]{1,64}$",
  "root.attributes.date.field": "date",
  "root.attributes.date.type": "S",
  "root.attributes.date.required": "True",
  "root.attributes.date.source_required": "True",
  "root.attributes.date.server_generated": "False",
  "root.attributes.date.autogenerated": "False",
  "root.attributes.date.frontend_autocomputed": "False",
  "root.attributes.date.regex": "^\\d{4}-\\d{2}-\\d{2}$",
  "root.attributes.shift.field": "shift",
  "root.attributes.shift.type": "S",
  "root.attributes.shift.required": "True",
  "root.attributes.shift.source_required": "True",
  "root.attributes.shift.server_generated": "False",
  "root.attributes.shift.autogenerated": "False",
  "root.attributes.shift.frontend_autocomputed": "False",
  "root.attributes.shift.regex": "^(morning|afternoon|night)$",
  "root.attributes.customer_name.field": "customer_name",
  "root.attributes.customer_name.type": "S",
  "root.attributes.customer_name.required": "True",
  "root.attributes.customer_name.source_required": "True",
  "root.attributes.customer_name.server_generated": "False",
  "root.attributes.customer_name.autogenerated": "False",
  "root.attributes.customer_name.frontend_autocomputed": "False",
  "root.attributes.customer_name.regex": "^[A-Za-z0-9 .,'_-]{1,120}$",
  "root.attributes.plate_number.field": "plate_number",
  "root.attributes.plate_number.type": "S",
  "root.attributes.plate_number.required": "False",
  "root.attributes.plate_number.source_required": "False",
  "root.attributes.plate_number.server_generated": "False",
  "root.attributes.plate_number.autogenerated": "False",
  "root.attributes.plate_number.frontend_autocomputed": "False",
  "root.attributes.plate_number.regex": "^[A-Za-z0-9 ._-]{1,30}$",
  "root.attributes.payment_method.field": "payment_method",
  "root.attributes.payment_method.type": "S",
  "root.attributes.payment_method.required": "True",
  "root.attributes.payment_method.source_required": "True",
  "root.attributes.payment_method.server_generated": "False",
  "root.attributes.payment_method.autogenerated": "False",
  "root.attributes.payment_method.frontend_autocomputed": "False",
  "root.attributes.payment_method.regex": "^(cash|gcash|maya|credit_card|debit_card|bank_transfer|check|fleet_card|other)$",
  "root.attributes.total_liters.field": "total_liters",
  "root.attributes.total_liters.type": "N",
  "root.attributes.total_liters.required": "True",
  "root.attributes.total_liters.source_required": "True",
  "root.attributes.total_liters.server_generated": "False",
  "root.attributes.total_liters.autogenerated": "False",
  "root.attributes.total_liters.frontend_autocomputed": "False",
  "root.attributes.total_liters.regex": "^-?\\d+(\\.\\d+)?$",
  "root.attributes.total_amount.field": "total_amount",
  "root.attributes.total_amount.type": "N",
  "root.attributes.total_amount.required": "True",
  "root.attributes.total_amount.source_required": "True",
  "root.attributes.total_amount.server_generated": "False",
  "root.attributes.total_amount.autogenerated": "False",
  "root.attributes.total_amount.frontend_autocomputed": "False",
  "root.attributes.total_amount.regex": "^-?\\d+(\\.\\d+)?$",
  "root.attributes.notes.field": "notes",
  "root.attributes.notes.type": "S",
  "root.attributes.notes.required": "False",
  "root.attributes.notes.source_required": "False",
  "root.attributes.notes.server_generated": "False",
  "root.attributes.notes.autogenerated": "False",
  "root.attributes.notes.frontend_autocomputed": "False",
  "root.attributes.notes.regex": "^.{0,500}$",
  "root.attributes.status.field": "status",
  "root.attributes.status.type": "S",
  "root.attributes.status.required": "True",
  "root.attributes.status.source_required": "True",
  "root.attributes.status.server_generated": "False",
  "root.attributes.status.autogenerated": "False",
  "root.attributes.status.frontend_autocomputed": "False",
  "root.attributes.status.regex": "^(draft|submitted|approved|cancelled)$",
  "root.attributes.created.field": "created",
  "root.attributes.created.type": "S",
  "root.attributes.created.required": "False",
  "root.attributes.created.source_required": "True",
  "root.attributes.created.server_generated": "True",
  "root.attributes.created.autogenerated": "False",
  "root.attributes.created.frontend_autocomputed": "False",
  "root.attributes.created.format": "iso8601",
  "root.attributes.created.regex": "^\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}(\\.\\d{1,6})?Z?$",
  "root.attributes.updated.field": "updated",
  "root.attributes.updated.type": "S",
  "root.attributes.updated.required": "False",
  "root.attributes.updated.source_required": "True",
  "root.attributes.updated.server_generated": "True",
  "root.attributes.updated.autogenerated": "False",
  "root.attributes.updated.frontend_autocomputed": "False",
  "root.attributes.updated.format": "iso8601",
  "root.attributes.updated.regex": "^\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}(\\.\\d{1,6})?Z?$"
}

Response Schema

{
  "type": "object",
  "properties.ok.type": "boolean",
  "properties.accepted.type": "boolean",
  "properties.is_committed.type": "boolean",
  "properties.request_id.type": "string",
  "properties.message.type": "string",
  "properties.table.type": "string",
  "properties.operation.type": "string",
  "properties.primary_key.type": "string",
  "properties.primary_key_value.type": "string",
  "properties.item_write_count.type": "number",
  "properties.child_write_count.type": "number"
}

Request Payload

{
  "sales_invoice_id": "ca3647e3-e530-4038-a2f0-840c7101e468",
  "gas_station_id": "3fc3add0-150b-4b4e-9c0d-547815678627",
  "invoice_number": "value-001",
  "date": "2026-05-17",
  "shift": "value-001",
  "customer_name": "Sample Name",
  "plate_number": "value-001",
  "payment_method": "value-001",
  "total_liters": "1",
  "total_amount": "1",
  "notes": "value-001",
  "status": "value-001",
  "created": "2026-06-29T10:53:22Z",
  "updated": "2026-06-29T10:53:22Z",
  "children.jef-fuel-pump-inventories-sales-invoice-line-items[0].sales_invoice_line_item_id": "d9e72b30-082a-4891-9606-5bda1bc5eccd",
  "children.jef-fuel-pump-inventories-sales-invoice-line-items[0].sales_invoice_id": "ca3647e3-e530-4038-a2f0-840c7101e468",
  "children.jef-fuel-pump-inventories-sales-invoice-line-items[0].gas_station_id": "358366d9-fed5-45c6-8d2a-1973b82b7410",
  "children.jef-fuel-pump-inventories-sales-invoice-line-items[0].line_number": "1",
  "children.jef-fuel-pump-inventories-sales-invoice-line-items[0].pump_id": "566e8351-2cfe-48fd-8631-8442e1c1ae45",
  "children.jef-fuel-pump-inventories-sales-invoice-line-items[0].pump": "value-001",
  "children.jef-fuel-pump-inventories-sales-invoice-line-items[0].product": "value-001",
  "children.jef-fuel-pump-inventories-sales-invoice-line-items[0].liters": "1",
  "children.jef-fuel-pump-inventories-sales-invoice-line-items[0].price_per_liter": "1",
  "children.jef-fuel-pump-inventories-sales-invoice-line-items[0].total_amount": "1",
  "children.jef-fuel-pump-inventories-sales-invoice-line-items[0].created": "2026-06-29T10:53:22Z",
  "children.jef-fuel-pump-inventories-sales-invoice-line-items[0].updated": "2026-06-29T10:53:22Z"
}

Response

{
  "type": "object",
  "properties.ok.type": "boolean",
  "properties.accepted.type": "boolean",
  "properties.is_committed.type": "boolean",
  "properties.request_id.type": "string",
  "properties.message.type": "string",
  "properties.table.type": "string",
  "properties.operation.type": "string",
  "properties.primary_key.type": "string",
  "properties.primary_key_value.type": "string",
  "properties.item_write_count.type": "number",
  "properties.child_write_count.type": "number"
}

CMD curl

curl -X POST "https://fsqf5slhc1.execute-api.ap-southeast-1.amazonaws.com/prod/fuel-pump-inventories-sales-invoices-post-one" -H "Content-Type: application/json" --data-raw "{\"sales_invoice_id\": \"ca3647e3-e530-4038-a2f0-840c7101e468\", \"gas_station_id\": \"3fc3add0-150b-4b4e-9c0d-547815678627\", \"invoice_number\": \"value-001\", \"date\": \"2026-05-17\", \"shift\": \"value-001\", \"customer_name\": \"Sample Name\", \"plate_number\": \"value-001\", \"payment_method\": \"value-001\", \"total_liters\": 1, \"total_amount\": 1, \"notes\": \"value-001\", \"status\": \"value-001\", \"created\": \"2026-06-29T10:53:22Z\", \"updated\": \"2026-06-29T10:53:22Z\", \"children\": {\"jef-fuel-pump-inventories-sales-invoice-line-items\": [{\"sales_invoice_line_item_id\": \"d9e72b30-082a-4891-9606-5bda1bc5eccd\", \"sales_invoice_id\": \"ca3647e3-e530-4038-a2f0-840c7101e468\", \"gas_station_id\": \"358366d9-fed5-45c6-8d2a-1973b82b7410\", \"line_number\": 1, \"pump_id\": \"566e8351-2cfe-48fd-8631-8442e1c1ae45\", \"pump\": \"value-001\", \"product\": \"value-001\", \"liters\": 1, \"price_per_liter\": 1, \"total_amount\": 1, \"created\": \"2026-06-29T10:53:22Z\", \"updated\": \"2026-06-29T10:53:22Z\"}]}}"

PowerShell curl

curl.exe -X POST "https://fsqf5slhc1.execute-api.ap-southeast-1.amazonaws.com/prod/fuel-pump-inventories-sales-invoices-post-one" -H "Content-Type: application/json" --data-raw '{"sales_invoice_id": "ca3647e3-e530-4038-a2f0-840c7101e468", "gas_station_id": "3fc3add0-150b-4b4e-9c0d-547815678627", "invoice_number": "value-001", "date": "2026-05-17", "shift": "value-001", "customer_name": "Sample Name", "plate_number": "value-001", "payment_method": "value-001", "total_liters": 1, "total_amount": 1, "notes": "value-001", "status": "value-001", "created": "2026-06-29T10:53:22Z", "updated": "2026-06-29T10:53:22Z", "children": {"jef-fuel-pump-inventories-sales-invoice-line-items": [{"sales_invoice_line_item_id": "d9e72b30-082a-4891-9606-5bda1bc5eccd", "sales_invoice_id": "ca3647e3-e530-4038-a2f0-840c7101e468", "gas_station_id": "358366d9-fed5-45c6-8d2a-1973b82b7410", "line_number": 1, "pump_id": "566e8351-2cfe-48fd-8631-8442e1c1ae45", "pump": "value-001", "product": "value-001", "liters": 1, "price_per_liter": 1, "total_amount": 1, "created": "2026-06-29T10:53:22Z", "updated": "2026-06-29T10:53:22Z"}]}}'