function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
orzikorzik 

SForce Connector Tables

I was wondering if the tool displays all the tables available to user. Namely I was looking for Public Groups tables with no success. Is there anyone that can help me out here?

RON, the capability of merging two tables is very usefull Thanks!
gregory
ScotScot

Gregory,

The connector can get at any of the tables accessible through the API. If you use the wizard (which lists the tables available), it uses the API itself to get the list of tables.

For the public groups, you want the table named "Group".

Groups contains all groups -- more than the Public Groups. From my account, it looks like the Public Groups are those records in Groups where the Type is equal to "Regular".

Scot

orzikorzik
Thanks Scot, I was looking for Separate table for that...
One person can be in many groups, I believe that GroupMember table will store all the relationships?

Thanks for your help,
gregory
ScotScot
RE: groupmember ... yep, you've got it.  Scot
orzikorzik
Thanks,
gregory
orzikorzik
Additional questions...
I am trying to use join feature: IN
User ID (user table) and User/Group ID (groupmember table) have different field names and join doesnt work ... any solutions to that?
Thanks,
gregory
Ron HessRon Hess

no ready solution, but i'll put on my list of "wish it could do that"

thanks

orzikorzik
Thanks bunch!!