Integrace Apple Map Links, Loyverse, MySQL

Watch Customers

Triggers when customers are added or updated.

Watch Employees

Triggers when employees are added, updated, or deleted.

Watch Items

Triggers when items are added, updated, or deleted.

Watch Payment Types

Triggers when payment types are added, updated, or deleted.

Watch Receipts

Triggers when receipts are added, updated, or deleted.

Watch Stores

Triggers when stores are added, updated, or deleted.

Navigate to a Location

Creates a map link to navigate to a location.

Perform a Search

Performs a search.

View a Specific Location

Views a specific location.

Create a Customer

Creates a new customer.

Create an Item

Creates a new item.

Create an Item Variant

Creates a new variant of an item.

Create a Receipt

Creates a new receipt by the store ID.

Delete a Customer

Removes a customer by the customer ID.

Delete an Image

Removes an image of an item by the item ID.

Delete an Item

Removes an item by the item ID.

Get a Customer

Retrieves details of a customer by the customer ID.

Get an Employee

Retrieves details of an employee by the employee ID.

Get an Item

Retrieves details of an item by the item ID.

Get a Payment Type

Retrieves details of a payment type by the payment type ID.

Get a Receipt

Retrieves details of a receipt by the receipt number.

Get a Store

Retrieves details of a store by the store ID.

Make an API Call

Performs an arbitrary authorized API call.

Update a Customer

Updates a customer by the customer ID.

Update an Item

Updates an Item by the item ID.

Update a Variant

Updates a variant of an item by the variant ID.

Upload an Image

Uploads a new image of an item by the item ID.

Smazat řádky z tabulky

Spustit uloženou proceduru.

Upravit řádek v tabulce

Vlastní dotaz (pokročilé)

Vložit řádek do tabulky

Procházet recordset z uložené procedury

Prochází přijatý recordset jeden řádek po druhém.

List Customers

Retrieves details of a list of customers.

List Employees

Retrieves details of a list of employees.

List Items

Retrieves details of a list of items.

List Payment Types

Retrieves details of a list of payment types.

List Receipts

Retrieves details of a list of receipts.

List Stores

Retrieves details of a list of stores.

Načíst řádky z tabulky