Solved

Simulating SQL Like in the REST API /sr/search

  • 6 December 2023
  • 4 replies
  • 62 views

Badge

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

 

 

icon

Best answer by rgireyev 28 January 2024, 19:53

View original

4 replies

Badge

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%'

Badge

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. :(

Badge

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.

Badge

So, it seems like there is no API that allows one to simulate a LIKE clause of SQL. :(

 

Reply