Retrieve data from a related table like SQL LEFT JOIN

Data Service
1

Hi All,

I created a 1:1 relationship between “task” and “Users” table.
image

How do I make a single call to “Load Table Objects” to table “task” and get data from the related “Users” like the following SQL?
"SELECT u.name AS ‘Name’ , t.username FROM task t
LEFT JOIN Users u ON t.username = u.username "

Thanks.
Deric

2

Hello @Deric_Voon

Try this request:
GET
https://api.backendless.com/<appId>/<appiKey>/data/Task?property=username&property=requestor_uname_re.name

More info about Working wih Properties

3

Hi Vlad,
How do I call this REST API in the codeless environment and assign the returned data to Dynamic List.
Thanks.

4

It would be this:

image
image1184×748 60.4 KB

1 Like
5

Thanks. That solved my problem.
Thank you so much