You need to sign in to do that
Don't have an account?
Rob Waibel Jr
Using custom query in soap-API
I have the following query:
SELECT AccountId,Account.JDE_Number__c, SUM(Rollover_Points__c) FROM Contact
WHERE No_Longer_w_Account__c = false AND Rollover_Points__c > 0 Group By AccountID,Account.JDE_Number__c
I am using soap to connect to Sales force, I want to fill a QueryResult with teh results of this qury and place it in a .NET datatable.
Solution?
SELECT AccountId,Account.JDE_Number__c, SUM(Rollover_Points__c) FROM Contact
WHERE No_Longer_w_Account__c = false AND Rollover_Points__c > 0 Group By AccountID,Account.JDE_Number__c
I am using soap to connect to Sales force, I want to fill a QueryResult with teh results of this qury and place it in a .NET datatable.
Solution?
I used the AggregateResult method them iterated thru each record (like an xml)
Dim Record As New sForce.AggregateResult
If qr.records.Count > 0 Then
For Each Record In qr.records
nRow = DT.NewRow
nRow("AccountID") = Record.Any(0).InnerText.Replace(Chr(34), "")
nRow("TotalRollOver") = Record.Any(2).InnerText.Replace(Chr(34), "")
nRow("AN8") = Record.Any(1).InnerText.Replace(Chr(34), "")
DT.Rows.Add(nRow)
Next
End If
Works like a charm!