search

hiratake55 / RForcecom

RForcecom provides the connection to Force.com and Salesforce.com from R
http://cran.r-project.org/web/packages/RForcecom/index.html
Other
49 stars 25 forks source link

Query with multiple lookups return single concatenated field #6

Closed gnilrets closed 11 years ago

gnilrets commented 11 years ago

I ran the following query and was expecting to get back 4 fields in my data frame. Instead, I got back 3, one of them just named "Owner". The value of the "Owner" field was just a concatenation of Owner.Username and Owner.Name.

accounts <- rforcecom.query(session, 
                            "
select 
    Id,
    Name,
    Owner.Username,
    Owner.Name
from 
    Account 
LIMIT 1000
"
)

Great package though, thanks for your work!

gnilrets commented 11 years ago

Hmmm....

Something strange is going on. I installed the package in RStudio and it says that 0.4.1 is installed:

packageVersion("RForcecom") [1] ‘0.4.1’

However, when I type help("RForcecom"), I'm brought to a help screen for 0.3 instructions. Furthermore, I downloaded the code and when I run the rforcecom.query directly, it behaves as expected (I get all of the columns with the proper . in their names).

Could there be something wrong with the package? Could it be the 0.3 version of the package but it's reporting as 0.4.1?

hiratake55 commented 11 years ago

Thank you for reporting issues. I had just committed patched version and updated help document. It will be available on the CRAN in a few days.