Create new booking in bookeo using my custom table in SQL

[bhutanigaurav]

"Having an issue with bookeo -> Create booking.
There are no columns to update the payment details and additional fields added to the Bookeo custom fields. because of missing fields payment, booking always goes as pending in bookeo where as we have already received the payment by other means. Is there a way to update the payment received in bookeo and also push the additional custom fields(already enabled in Bookeo) to bookeo. Workflow already created in system with name "

Moving Bookings from Funpad to Bookeo

"

 

[Pabblymember11]

Hey @bhutanigaurav

Could you please tell us all the fields which you wanted in the action step to process the workflow, so that we can forward the requirement to our technical team?

 

[bhutanigaurav]

I believe you are calling the following API of Bookeo

Bookeo API Reference

and I want the following to be exposed to all of the below if possible but the minimum field required is to capture the total amount and some indicator to mark that payment has already been received.

CustomField {
id (string, optional): The id of the field. It must match the id of an existing customer custom field, as returned by a call to GET /settings/customercustomfields When creating or updating a customer, either the id or the name property are required. If both are supplied, Bookeo will only consider the id property.,
name (string, optional): The name of the field. It must match the name of an existing customer custom field, as returned by a call to GET /settings/customercustomfields When creating or updating a customer, either the id or the name property are required. If both are supplied, Bookeo will only consider the id property.,
value (string): The value of the field. For checkbox-type options, possible values are "true" and "false" For choice fields, this is the name (i.e. plain text) of the chosen value, not the id
}
Money {
amount (string): The amount. It is expressed as a string type to avoid the risk of rounding issues with floating point arithmetic when used to handle decimal amounts. Ex.: "16.50",
currency (string): Currency code in ISO 4217 format. Ex.: "USD"

Price {
totalGross (Money): The total gross price, inclusive of taxes, with possible discounts applied. [read-only],
totalNet (Money): The total net price, excluding taxes, with possible discounts applied. [read-only],
totalTaxes (Money): The total amount of taxes included in the gross price [read-only],
totalPaid (Money): The total amount paid so far. [read-only],
taxes (Array[PriceTax]): A breakdown of all taxes paid. [read-only]
}

Payment {
id (string): [read-only],
creationTime (date-time): When this record was created [read-only],
receivedTime (date-time): When this payment was received,
reason (string): Reason for the payment. Shown to customer where appropriate. Ex. "Deposit", "Balance payment", "Additional fee", etc,
description (string, optional): Indicates what the payment was for (ex. "Booking 1234", "Prepaid package ABC", "Gift voucher XYZ") [read-only],
comment (string, optional): An optional comment tracked with the payment. Not shown to customers.,
amount (Money): The payment amount,
paymentMethod (string) = ['creditCard' or 'paypal' or 'bankTransfer' or 'cash' or 'checque' or 'debitCard' or 'existingCredit' or 'accountCredit' or 'moneyVoucher' or 'other'],
paymentMethodOther (string, optional): If paymentMethod is 'other', this field is required, and it specifies what other method was used,
agent (string, optional): Who registered this payment. If this field is not present, it means that the customer paid online on Bookeo's booking page [read-only],
customerId (string, optional): The id of customer associated with this payment [read-only],
gatewayName (string, optional): The name of the payment gateway that processed the payment (if it was processed by a payment gateway) [read-only],
transactionId (string, optional): The transaction number/id as provided by the payment gateway that processed the payment - if any [read-only]
}

 

[Pabblymember11]

Hey @bhutanigaurav

We have forwarded your concern to our technical team and they are currently looking into it.

So, kindly allow us some time.

 

[bhutanigaurav]

Thanks, looking forward to it

 

[Pabblymember11]

Hey @bhutanigaurav

We have made the desired changes in the action step accordingly, kindly reconnect the action step once and let us know how it works for you.

 

[bhutanigaurav]

Thanks for the quick Reply, Customer additional fields are visible and passing on correctly how ever the additional option under services is still not visible and the payment is still going as pending. Not sure what need to be done to mark it as paid, please see below for more details

Additional option for services is still not visible

Payment option is still going as pending and the actual price is not getting passed. It is picking up the price from the package by default. Not sure for that you have to expose the following or just the price and initialpayment(show on following page) should be enough to pass it on

Payment {

id (string): [read-only],

creationTime (date-time): When this record was created [read-only],

receivedTime (date-time): When this payment was received,

reason (string): Reason for the payment. Shown to customer where appropriate. Ex. "Deposit", "Balance payment", "Additional fee", etc,

description (string, optional): Indicates what the payment was for (ex. "Booking 1234", "Prepaid package ABC", "Gift voucher XYZ") [read-only],

comment (string, optional): An optional comment tracked with the payment. Not shown to customers.,

amount (Money): The payment amount,

paymentMethod (string) = ['creditCard' or 'paypal' or 'bankTransfer' or 'cash' or 'checque' or 'debitCard' or 'existingCredit' or 'accountCredit' or 'moneyVoucher' or 'other'],

paymentMethodOther (string, optional): If paymentMethod is 'other', this field is required, and it specifies what other method was used,

agent (string, optional): Who registered this payment. If this field is not present, it means that the customer paid online on Bookeo's booking page [read-only],

customerId (string, optional): The id of customer associated with this payment [read-only],

gatewayName (string, optional): The name of the payment gateway that processed the payment (if it was processed by a payment gateway) [read-only],

transactionId (string, optional): The transaction number/id as provided by the payment gateway that processed the payment - if any [read-only]

}

price (Price, optional): Details about price, taxes, etc. [read-only],

initialPayments (Array[Payment], optional): When creating a new booking, an application can also record one or more payment associated to the booking (ex. if the customer has paid a deposit or the full amount online) This field is never set by Bookeo, and is ignored unless this is a new booking being created.,

 

[Pabblymember11]

Please post the submission on the platform here, if you have any further requirements in the action step- https://pabbly.hellonext.co/

 

[bhutanigaurav]

Please post the submission on the platform here, if you have any further requirements in the action step- https://pabbly.hellonext.co/

Thanks there, You have fixed some parts of it now don't put it in the backlog for new development. Just need one more thing to tick the payment is already made that's it probably one more column that needs to be added. that's it other things can go into the backlog. This is a must-have other things are nice to have. Please please forward this to your development team.

 

[Pabblymember11]

This is a must-have other things are nice to have. Please please forward this to your development team.

You may add the suggestion on the given submission on the platform.

https://pabbly.hellonext.co/