Hello.
We used to host SysAid locally and I had the following query that went to the local DB directly.
SELECT id FROM service_req WHERE sr_cust_sap_transports Like '%123456789%’
Now that we moved to the SysAid cloud I need to redo this query using the REST API.
Would like assistance in this translation. :)
Thank you
Rudy
Best answer by rgireyev
So, it seems like there is no API that allows one to simulate a LIKE clause of SQL. :(
More info. I’m trying the following, however am getting the “Error 504 - Request time out” :(
https://[mycom].sysaidit.com/api/v1/sr/search?sr_cust_sap_transports like '%123456789%'
It seems like I get a result if I limit the amount of data brought back. Either with the limit parameter or with the fields parameter. But it doesn’t look like the data that is brought back is correct. :(
Hello Rudy,
This message is to inform you that we have opened you an internal ticket where we will email you from it as we would require some additional details to have a better understanding of your request →
#2457674 would be the reference.
Wish you all the best.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
