Hi
i have 3 table :
ProductTable
OrderTable [ with product_id , user_id ]
UserTable
i want to get OrderTable Rows involve user details [ name ,… ]and product details [ name , … ] with one request to Backendless api
how i can reach to this goal ?
Have you read about relations between Data tables in Backendless? If not:
- relations overview. This will explain what is relations, how to set up relations structure in Backendless console etc - https://backendless.com/docs/rest/data_relations.html
- setting/adding relations between tables API - https://backendless.com/docs/rest/data_set_add_relation_rest.html
- retrieving related objects - https://backendless.com/docs/rest/data_relations_retrieve_overview.html
So in your case you would need to have a relation from table OrderTable to the other two tables (ProductTable, Users). Then when all relations between rows will be set - you will need to run a GET request against OrderTable table. If you face any difficulties later on - do not hesitate to ask additional questions here or in our Slack channel
Anton