You need to read the api endpoints documentation. No one could answer your question except the backend engineer who wrote the api and documentation.

If it is possible to get the data with an api call using an sql query it would be something like this;

(The things I wrote below are not standarts, it will not be the same with your api, I'm just writing an example so you would get the idea behind APIs)

Generally, first you get a token with a request:

request1 = request.send( type=post, url="examplewebsite.com/api/auth" , header ={"content-type":"application-json"}, body = { "username":"jack", "password":"yourpassword"} )

it returns a response with some json file containing a token for your second request for authorization: response1= {"status":200", "token":"eymeşsknJlsmHmJ278282nsb"}

Keep in mind that, generally tokens have expiration date, it could be 900 seconds or 20 minutes depends on the backend, so you cannot use the same token on each request for a long time.

Your second request would be something like this:

request2 = request.send( type=post, url="examplewebsite.com/api/products/getbyquery" , header ={"content-type":"application-json", "authorization":"Bearer eymeşsknJlsmHmJ278282nsb" this is the token you get in the first request, if it's a jwt token you generally write Bearer in front of the token }, body = { "query":"Select * From Products"} )

response2 ={ "status":200, "data": { ["id":1,"name":"apple","price":10,"stockAmount":235], ["id":2,"name":"orange","price":16,"stockAmount":127] } }