Sign Up ›
  • Sidharth12
  • NEWBIE
  • 0 Points
  • Member since 2012
  • Chatter
    Feed
  • 0
    Best Answers
  • 2
    Likes Received
  • 0
    Likes Given
  • 4
    Questions
  • 1
    Replies
0 replies

How to iterate SOQL join query results in Excel Macro

Could you please provide an example how to iterate the join queries in VBA
Dim qr As QueryResultSet4
qr = g_sfApi.Query("select name,( select id from contacts )  from account ",false)

qr is always null even though data is there, could you please help to fix the issue. 

Thanks
8 replies

How to get deleted records info from Salesforce through REST API

We are doing iOS Mobile app integration with Salesforce through REST API. For the syncing prospective we also need to get the deleted records info from SFDC. When we are using SOQL "SELECT IsDeleted,Name FROM Table__c ALL ROWS", it is not fetching the deleted records. Is there any way to achieve this?

 

Thanks,

Sid

0 replies

Profiles option is not available in Manage Users in 30days trial of unlimited edition of Sales Cloud

I have enrolled to a 30days trial of unlimited edition of "Sales" cloud app. But unable to see the "Profile" option in Setup>Admin Setup>Manage Users. If any one has any infortion on this, please share.

 

Thanks,

Sid

----------------------------------------

Sales Cloud

 

Unlimited

Premier+ Success Plan optimizes CRM for your business

$250
/user/month*
30-day free trial

 

Includes all Enterprise Edition features plus: 
----------------------------------------------------------------
3 replies

Outbound integration to SAP-401 unauthorized issue

Hi There,

 

We are trying to integrate salesforce-SAP systems. SAP using SAP PI system and we imported the WSDL from SAP but the generated class dosnt contain any user id and password parameter. But the WSDL working fine when used in SOAP UI because SOAP UI asks for user id and password parameters in runtime but in salesforce we can not provide it in runtime. Even the XML file which we got from SAP doesnt contain any user id and password param neither in header nor in body.

 

we tried a http call by putting the user id and password in the header section but we are getting 401 unauthorized  error.

Is there any way to resolve the issue? how can we get the exact request which hits to SAP server in XML format from SAP? please suggest.

 

Thanks,

Sid

8 replies

How to get deleted records info from Salesforce through REST API

We are doing iOS Mobile app integration with Salesforce through REST API. For the syncing prospective we also need to get the deleted records info from SFDC. When we are using SOQL "SELECT IsDeleted,Name FROM Table__c ALL ROWS", it is not fetching the deleted records. Is there any way to achieve this?

 

Thanks,

Sid

3 replies

Outbound integration to SAP-401 unauthorized issue

Hi There,

 

We are trying to integrate salesforce-SAP systems. SAP using SAP PI system and we imported the WSDL from SAP but the generated class dosnt contain any user id and password parameter. But the WSDL working fine when used in SOAP UI because SOAP UI asks for user id and password parameters in runtime but in salesforce we can not provide it in runtime. Even the XML file which we got from SAP doesnt contain any user id and password param neither in header nor in body.

 

we tried a http call by putting the user id and password in the header section but we are getting 401 unauthorized  error.

Is there any way to resolve the issue? how can we get the exact request which hits to SAP server in XML format from SAP? please suggest.

 

Thanks,

Sid