If you think that something doesn't work in Aware IM post your message here
#52774 by cishpix
Fri Jan 17, 2020 11:50 am
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

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

    pic1.png
    the data respond as array when call via REST API
    pic1.png (32.01 KiB) Viewed 611 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

    pic2.png
    detail respond when we call a name
    pic2.png (145.88 KiB) Viewed 611 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?

  2. 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?

    pic3.png
    error when delete a record contain space
    pic3.png (49.21 KiB) Viewed 611 times

    It will run well if not contain space.

  3. See the detail respond, how can I input "2020-01-17 18:20:11.982003" into timestamp?
#52786 by himanshu
Sat Jan 18, 2020 9:39 am
try to encode URL while posting... like for spaces %20 and for other special characters.
#52815 by cishpix
Tue Jan 21, 2020 9:59 am
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?
#52816 by himanshu
Tue Jan 21, 2020 10:18 am
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.
#52817 by cishpix
Tue Jan 21, 2020 10:31 am
himanshu wrote:item#3
Question: Which database you are using?

Hi Himanshu, thanks for your respond. I use MariaDB
#52819 by cishpix
Tue Jan 21, 2020 11:42 am
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?

Who is online

Users browsing this forum: MSN [Bot] and 6 guests