Problem REST API in AwareIM

cishpix

Currently I'm still try CRUD in REST Service from AwareIM and the other application is ERPNext.

There are 2 problems and I'm sure it is AwareIM issue because I have test it in other application like Postman

ERPNext will respond the data as array (see the below) when we call GET via REST API service from AwareIM

If we want to get full details of the records then we need include the name into "Base URL" of REST Service in AwareIM. The reply like below

In AwareIM, I want to show all the data as query table. So, I design a process to call first REST Service to GET all the data (array), the second REST Service will called in rule when it get the reply from first REST Service. The problem is AwareIM need around 1 minute to get all details and it just show loading icon. How can I solve it?
When I delete a data, I got an error in AwareIM (see below). The issue can appear when the "Base URL" of Rest Service contain space. How to solve this issue?

It will run well if not contain space.
See the detail respond, how can I input "2020-01-17 18:20:11.982003" into timestamp?

himanshu

try to encode URL while posting... like for spaces %20 and for other special characters.

cishpix

himanshu wrote
try to encode URL while posting... like for spaces %20 and for other special characters.

Thanks for your respond and it works (item #2)

Still stuck on item #1 and item #3, any idea?

himanshu

item#3
Question: Which database you are using?

if your database MS SQL you just need to change the specific attribute datatype to "datetime2". This will allow saving the your datetime in format (eg: "YYYY-MM-DD hh:mm:ss.nnnnnnn") it means it includes nanoseconds.

cishpix

himanshu wrote
item#3
Question: Which database you are using?

Hi Himanshu, thanks for your respond. I use MariaDB

himanshu

Hi Lie,

I believe it supports too...
as said below
https://mariadb.com/kb/en/datetime/

cishpix

himanshu wrote
I believe it supports too...
as said below
https://mariadb.com/kb/en/datetime/

Many thanks for you Himanshu. I have try set the "SQL Type" to datetime(6) (for the attribute) but unfortunately it doesn't work. At least, it doesn't give any error for the timestamp.

I Shall try take a time to look in details.

Do you know how to solve the item#1?