Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to loading Opportunity object from salesforce where the fields will be
Salesforce Object Field's:
select
Opportunity_ID__c,
Win_Loss_Reason__c,
Amount,
Tier_1_Opportunity_Value__c
FROM Opportunity
Script in Qlikview:
CUSTOM CONNECT*Provider*QlikSalesforceConnector.exe*XUserId*XPassword*
LET vAuditStartTime = Now(1);
Opportunities:
Load Opportunity_ID__c,
Win_Loss_Reason__c,
Amount as converted1,
Tier_1_Opportunity_Value__c as converted ;
SQL SELECT
Opportunity_ID__c,
Win_Loss_Reason__c,
[convertcurrency(Amount)],
[convertcurrency(Tier_1_Opportunity_Value__c)]
FROM Opportunity ;
Earlier i am using salesforce connector 11.0.1 and i have no issue but now getting the ERROR
Error: Unable to get column information for the fields that are used in the query: Length cannot be less than zero.
Parameter name: length
General Script Error
Execution Failed
I think Data Type's are not Supported to QlikSalesforceConnector.exe Version 13.1.0..Please any one help on this?
Example:
[convertcurrency(Amount)],
[convertcurrency(Tier_1_Opportunity_Value__c)]
Hi Prathap,
If you're not doing convertcurrency, but just pulling the fields as-is, does it work?
Hi Prathap,
If you're not doing convertcurrency, but just pulling the fields as-is, does it work?
yes its working if we just pulling the fields as-is,,
Issue is only when we use convertcurrency
getting below error while loading
Unable to get column information for the fields that are used in the query. Please make sure you have only one SELECT statement in a query editor. Description: Length cannot be less than zero.
Parameter name: length
SQL SELECT
Opportunity_ID__c,
Win_Loss_Reason__c,
[convertCurrency(Amount)],
[convertCurrency(Tier_1_Opportunity_Value__c)]
FROM Opportunity