Function with REST call - Where clause

Using a REST service call in code, I’m struggling to pass a where clause with multiple parameters. The goal is to get a list of records that satisfy the where clause, and select the row with the highest “Key2” value.


This line, when tested through Postman, returns the “Sorry! Something went wrong.” generic error. I believe it’s due to the where clause being incorrect.

The “tempUD38” variable is just set up as a new UD38Tableset:
image

Any insight on how to get this service call to work properly, or suggestions on an easier way to get the existing record with the highest Key2 would be appreciated!

Thanks

Maybe helpful:

This is the where clause used when testing on the API, currently returns 3 records, which is the expected result.

Do you have access to server? You can find exact details for the generic error in the server log or event viewer.

We are running off of the cloud servers, from my understanding that means we do not have direct access to those server logs.

@klincecum’s got you.

https://www.epiusers.help/t/server-event-log-dashboard/97855

He needs to watch out for the rhythm though.

It’ll get you too :notes:

Sonny And Cher GIF by The Ed Sullivan Show

1 Like