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
jlimjlim 

Perl - pricebook detail from Standard pricebook coming up empty

Using the Perl API, if I'm querying from an opportunity line item that is referencing the "Standard" pricebook, I'm not getting any details from the pricebookentry. The same query, if pass an id that contains item from our customized "Software" pricebook, will return the pricebookentry details (such as product code, countryisocode etc.)

 

Can someone who is using Perl API give it a try and report back if you are experiencing the same issue?

 

I'm using this version of the Perl API: WWW-Salesforce-0.11

 

http://search.cpan.org/dist/WWW-Salesforce/

 

I've tried  the following versions:

 

https://www.salesforce.com/services/Soap/c/13.0';

https://www.salesforce.com/services/Soap/c/16.0'; 

https://www.salesforce.com/services/Soap/u/13.0';

https://www.salesforce.com/services/Soap/u/16.0'; 

 

 

This is the partial SOAP XML responses:

 

 

<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Header> <sforce:QueryOptions xmlns:sforce="urn:partner.soap.sforce.com"> <batchSize xsi:type="xsd:int">500</batchSize> </sforce:QueryOptions> <sforce:SessionHeader xmlns:sforce="urn:partner.soap.sforce.com"> <sessionId xsi:type="xsd:string">xxxx</sessionId> </sforce:SessionHeader> </soap:Header> <soap:Body> <query xmlns="urn:partner.soap.sforce.com"> <queryString xsi:type="xsd:string"> SELECT oli.Product_Class__c, oli.Product_Type__c, oli.PricebookEntry.ProductCode FROM OpportunityLineItem oli WHERE oli.OpportunityId='xxxx' </queryString> </query> </soap:Body> </soap:Envelope>

 


 
This is what I'm getting back. I highlighted in RED where the pricebook entry info is not coming back
 

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns="urn:partner.soap.sforce.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:sf="urn:sobject.partner.soap.sforce.com"> <soapenv:Body> <queryResponse> <result xsi:type="QueryResult"> <done>true</done> <queryLocator xsi:nil="true"/> <records xsi:type="sf:sObject"> <sf:type>OpportunityLineItem</sf:type> <sf:Id xsi:nil="true"/> <sf:Product_Class__c>Lease</sf:Product_Class__c> <sf:Product_Type__c>New Product</sf:Product_Type__c> <sf:PricebookEntry xsi:nil="true"/> </records> <records xsi:type="sf:sObject"> <sf:type>OpportunityLineItem</sf:type> <sf:Id xsi:nil="true"/> <sf:Product_Class__c>Lease</sf:Product_Class__c> <sf:Product_Type__c>New Product</sf:Product_Type__c> <sf:PricebookEntry xsi:nil="true"/> </records> <size>2</size> </result> </queryResponse> </soapenv:Body> </soapenv:Envelope>

 


 
If I'm selecting an Opportunity from our "Software" pricebook: In, blue below, you can see this info was missing from the above results.
 

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns="urn:partner.soap.sforce.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:sf="urn:sobject.partner.soap.sforce.com"> <soapenv:Body> <queryResponse> <result xsi:type="QueryResult"> <done>true</done> <queryLocator xsi:nil="true"/> <records xsi:type="sf:sObject"> <sf:type>OpportunityLineItem</sf:type> <sf:Id xsi:nil="true"/> <sf:Product_Class__c>Maintenance</sf:Product_Class__c> <sf:Product_Type__c>Renewal</sf:Product_Type__c> <sf:PricebookEntry xsi:type="sf:sObject"> <sf:type>PricebookEntry</sf:type> <sf:Id xsi:nil="true"/> <sf:ProductCode>GWU-FLT-MNT</sf:ProductCode> </sf:PricebookEntry> </records> <size>1</size> </result> </queryResponse> </soapenv:Body> </soapenv:Envelope>

 


 

 

 

 

Message Edited by jlim on 09-24-2009 03:51 PM