Query API . Expose all fields that that require a join for lookup
From Query API documentation it seems that there is a limitation according to which we can only use only two relation join in the select query column.
However I wanted to know if there is any way to get for example: Owner.FistName,CreatedBy.FirstName,ModifiedBy.FirtName in the same select * query using the relations that Accounts Table has with Users Table.
For example in the metadata of Accounts table we can detect lookup fields and then send another request to get FirstName, LastName from Users for each column and point to another endpoint from which we could get we could get all the columns for each lookup column without getting an error.
for example the query could look like :
{
"select_query":"select ParentId.Owner.first_name,ParentId.Created_By.first_name,ParentId.Modified_By.first_name from Accounts where id is not null"
}
I am not quite sure
Could you help?