You need to sign in to do that
Don't have an account?
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>
<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>
<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>