Support Topics Documentation Slack YouTube Blog

Help Defining API Get

Hi Everyone,

I’m trying to get a better understanding of API Get calls while doing the missions. I have a table QuickGames with a QGameID column, which is populated by an auto number for each record. My API Get example pulls the whole list of example records, invokes in simple way. What I don’t know how to do is create a where clause in the API logic to refine the pull. In the Rest Console I can use the following to pull only records where all there corresponding status fields are set to boolean value of false.

where QGamesQueued=false AND QGamesActive=false AND QGamesCompleted

See attached graphics for specifics, and any help is appreciated.

Found my answer.

1 Like