Forum Discussion

SteveRudd's avatar
SteveRudd
Helper I
8 years ago
Solved

Connection to Salesforce reports not working in latest version 2.61.5192.601

Since updating to the latest version I can no longer query salesforce reports.    I can connect to Salesforce Objects but not reports.    The only change has been to update to the latest version....
  • Anonymous's avatar
    Anonymous
    8 years ago

    SteveRudd,

    Expand required table from Data column.

    Regards,

    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

SteveRudd,

Please paste the above code to the Advanced Editor of the blank query. there is an example for your reference.


Regards,
Lydia

SteveRudd's avatar
SteveRudd
Helper I
8 years ago

Thanks Anonymous that looks better :-) 

pic 2

  • SteveRudd's avatar
    SteveRudd
    Helper I
    8 years ago

    also this only pulls the first 200 lines, unfortunately this doesn't work for what I need

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    SteveRudd,

    Expand required table from Data column.

    Regards,

    Lydia

  • SteveRudd's avatar
    SteveRudd
    Helper I
    8 years ago

    great thanks, any ideas why this is not working through the normal GUI?

  • SteveRudd's avatar
    SteveRudd
    Helper I
    8 years ago

    I have managed to see the report I need by sorting in descending order

  • RubinaHussain's avatar
    RubinaHussain
    Frequent Visitor
    7 years ago

    Hi Lydia,

     

    I used this technique as you mentioned and my hopes were high as for the first time, I could see few data columns from expand section. I selected few data coloumns of my choice, and when i tried to save and close the query. they asked me to login to my salesforce account. Once I did that. it sent me message

     

    you are already signed in 

     

    ' access to the resource is forbidden". Sign in as a diff user.

     

    Regards

    Rubina