Hello. I’m a Korean developer.
I’m thinking of a program that will process Q&A using Chatbot.

I want to control DB by inserting chatscript to programs that use the existing jsp, oracle db.

Can it use a restful api and Json to communicate with an oracle database?

I eagerly await your advice.

^jsonopen can send and receive json to any site supporting such api

Bruce Wilcox - Jan 4, 2018:

^jsonopen can send and receive json to any site supporting such api

So, is this okay?

step1. Create an API to send and receive data from existing systems.

step2. Use the “^ jasonopen” in the Chatbot to send and receive data.

Do I need to create a service group on both systems to process data?

I am sorry for my poor English.

If the service already exists (like weatherunderground) then you dont do step 1. If you are trying to connect chatscript to an oracle database then probably yes, you need to create an api to chat to your local oracle instance

^jsonopen is told the web adress to send a get or post, which kind of request to send, if a put, what json text string to send, and various other parameters.  The data is returned to chatscript directly as json fact data (decoded from the return text string) and you write whatever chatscript script you want to process the data.

Bruce Wilcox - Jan 5, 2018:

If the service already exists (like weatherunderground) then you dont do step 1. If you are trying to connect chatscript to an oracle database then probably yes, you need to create an api to chat to your local oracle instance

^jsonopen is told the web adress to send a get or post, which kind of request to send, if a put, what json text string to send, and various other parameters.  The data is returned to chatscript directly as json fact data (decoded from the return text string) and you write whatever chatscript script you want to process the data.

I want to call and use a Chatbot server from an external program.
So, I wondered if my logic was possible.

Oracle API ——JSON——> ^jasonopen (get) ChatScript Service
Oracle API <—-JSON——- ^jasonopen (post) chatScript Service

Thank you for your reply.

Chatscript is a server that has its own protocol. So typically you have some intermediary server passing messages to it and taking its output and sending it back. In my case, for example, I have a webpage that you interact with that sends your input to the server and displays its output back to you. And you can pass json data as out-of-band message to the server.