getDataObj vs selectQuery to return field data for multiple

Posted by Rollbase User on 01-Mar-2013 13:35

Is there some way, with a single call, I can fetch field data from a table, that includes the integration names for picklist values. It seems I have 2 choices: 1. Use selectQuery to query for multiple records. Then for each field that contains a pick list do a separate getCodeById call. 2. Call detailedSearch to get an array of ids Then for each id call getDataObj with useIds set to false. Or maybe there is some other way to reduce the network traffic? Seems like what I want is a new method called getDataObjArr where I pass in an array of ids and it returns an array of DataFields Thanks!

All Replies

Posted by Admin on 01-Mar-2013 13:48

Please use #code suffix for picklist fields used in selectQuery (any Rollbase API). That will fetch integration codes instead of IDs.



Please see Chapter 6 for more info.

Posted by Admin on 01-Mar-2013 14:05

Ahh much better. Thanks so much!

Posted by Admin on 13-Jun-2013 09:00

I'm using the SOAP API's selectQuery method.



Besides #code, is there any way to access the fields of a loopup relationship? For example, suppose I have an Employee object with a lookup to a Company object.



When doing a selectQuery on the Employee, is there a way to also fetch the Record Name of the Company?



Something like "company#name"



Or do I need to do a second selectQuery?

This thread is closed