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
the data respond as array when call via REST API
pic1.png (32.01 KiB) Viewed 12230 times
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
detail respond when we call a name
pic2.png (145.88 KiB) Viewed 12230 times
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?
error when delete a record contain space
pic3.png (49.21 KiB) Viewed 12230 times
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?
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.
From,
Himanshu Jain
AwareIM Consultant (since version 4.0)
OS: Windows 10.0, Mac
DB: MYSQL, MSSQL
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.