API Integration examples

Jonathan

Good day team

Is there any guidance documentation on integrating a chatbot with a database like Astra DB using REST APIs? I do not have in-depth programming experience. I have already built everything else in my bot but my challenge now is integrating with my database using REST APIs. Can anyone assist?

Kind regards

admin

Hi Jon,

Can you upload a sample?
And describe what exactly you are expecting to happen

Jonathan

Okay so what I want to do is as follows:
I have built a chatbot which I am going to publish on the WhatsApp channel. This bot enables businesses to register their businesses, supplying information like Business Name, address, phone number, Whatsapp link for their WhatsApp business catalogue, and products or services they offer. This information will then be put in the format of key-value pairs as follows
business name : @business_name
address : @address
phone : @business_phone
unique_id : @business_id (primary key)
etc
This information should then be updated in the database using the HTTP POST method.

When users search for a business that supplies goods or services that he or she is looking for, I would like to use the HTTP GET method to filter resources that meet this criterion and then show the results to the user.

In addition, I would want to then use the PATCH/PUT and DELETE methods to modify the records that will be in the database.

admin

There are several examples. Pls familiarize yourself and ask specific questions if you do not understand something.
Pls download these templates and import them to your Promptchat account templates. From there you can open them.

test-api.zip

1kB

and

api-send-message-to-phone.zip

1kB

Jonathan

Thank you. Let me do so.

admin

See this example too. https://forum.promptchat.com/d/28-write-a-variable-in-the-url-in-the-block-api

Jonathan

Good morning

That was very helpful thank you. Is there a way to add a variable in a JSON file? For example, I want to update my database using the PUT method and in the body of the API I need to put { "key": "value"} but for my value I want it to be a value of a variable inside the bot.

Alla

Jonathan
You can do like in example:
@phone = +38096XXXXXXX // this variable is set somewhere in the bot chat
$email = some-email@gmail.come // this is global variable

{
"text": "some text",
"phone": "{@phone}",
"email": "{$email}"
}

Jonathan

Alla Thank you very much let me try that.

Jonathan

Alla It worked perfectly. Thank you.