Happy Business Starts Here

New Student

Error Post Request Payload

Hello

 

I am trying to pull data from Product Rate Plan Charge using Informatica Cloud. The Informatica is throwing Zuora error as below. Any help will be greatly appreciated.

 

"errorCode" : "90005",
"message" : "There is a syntax error in one of the queries in the AQuA input",
"batches" : [ {
"localizedStatus" : "pending",
"recordCount" : 0,
"apiVersion" : "82.0",
"batchType" : "zoqlexport",
"full" : true,
"status" : "pending",
"name" : "ProductRatePlanCharge",
"query" : "SELECT ProductRatePlanCharge.AccountingCode, ProductRatePlanCharge.ApplyDiscountTo, ProductRatePlanCharge.Area__c, ProductRatePlanCharge.BillCycleDay, ProductRatePlanCharge.BillCycleType, ProductRatePlanCharge.BillingPeriod, ProductRatePlanCharge.BillingPeriodAlignment, ProductRatePlanCharge.BillingTiming, ProductRatePlanCharge.ChargeModel, ProductRatePlanCharge.ChargeType, ProductRatePlanCharge.Complimentary__c, ProductRatePlanCharge.Component_Distributor__c, ProductRatePlanCharge.Country__c, ProductRatePlanCharge.CreatedById, ProductRatePlanCharge.CreatedDate, ProductRatePlanCharge.CUSIPProduct__c, ProductRatePlanCharge.Data_Provider_Exchange__c, ProductRatePlanCharge.Default_Trial_Length__c, ProductRatePlanCharge.DefaultQuantity, ProductRatePlanCharge.DeferredRevenueAccount, ProductRatePlanCharge.Delivery_Format__c, ProductRatePlanCharge.Delivery_Frequency__c, ProductRatePlanCharge.Delivery_Type__c, ProductRatePlanCharge.Department__c, ProductRatePlanCharge.Description, ProductRatePlanCharge.DiscountLevel, ProductRatePlanCharge.Distributor_Platform__c, ProductRatePlanCharge.Edition__c, ProductRatePlanCharge.Email_ID_Required__c, ProductRatePlanCharge.EndDateCondition, ProductRatePlanCharge.Finance_Spart_Override__c, ProductRatePlanCharge.Fulfillment_Code__c, ProductRatePlanCharge.FulFillment_Code_Indicator__c, ProductRatePlanCharge.Fulfillment_End_Date__c, ProductRatePlanCharge.Fulfillment_Start_Date__c, ProductRatePlanCharge.GeoCode__c, ProductRatePlanCharge.Id, ProductRatePlanCharge.IncludedUnits, ProductRatePlanCharge.Invoice_Display_Name__c, ProductRatePlanCharge.Invoiceable_End_Date__c, ProductRatePlanCharge.Invoiceable_Start_Date__c, ProductRatePlanCharge.Is_Digital__c, ProductRatePlanCharge.Is_Spart__c, ProductRatePlanCharge.Language__c, ProductRatePlanCharge.LegacyRevenueReporting, ProductRatePlanCharge.License_Type__c, ProductRatePlanCharge.ListPriceBase, ProductRatePlanCharge.MaxQuantity, ProductRatePlanCharge.MinQuantity, ProductRatePlanCharge.Name, ProductRatePlanCharge.NumberOfPeriod, ProductRatePlanCharge.OverageCalculationOption, ProductRatePlanCharge.OverageUnusedUnitsCreditOption, ProductRatePlanCharge.PriceChangeOption, ProductRatePlanCharge.PriceIncreasePercentage, ProductRatePlanCharge.Product_Offering_ID__c, ProductRatePlanCharge.Product_Type_Option__c, ProductRatePlanCharge.RatingGroup, ProductRatePlanCharge.RecognizedRevenueAccount, ProductRatePlanCharge.Region__c, ProductRatePlanCharge.Renew_Product_As__c, ProductRatePlanCharge.Revenue_Component_Allocation__c, ProductRatePlanCharge.Revenue_Share__c, ProductRatePlanCharge.RevenueRecognitionRuleName, ProductRatePlanCharge.RevRecCode, ProductRatePlanCharge.RevRecTriggerCondition, ProductRatePlanCharge.Sellable_eCommerce__c, ProductRatePlanCharge.Service_Level__c, ProductRatePlanCharge.SmoothingModel, ProductRatePlanCharge.SpecificBillingPeriod, ProductRatePlanCharge.Standalone_Sellable__c, ProductRatePlanCharge.State__c, ProductRatePlanCharge.Taxable, ProductRatePlanCharge.TaxCode, ProductRatePlanCharge.TaxMode, ProductRatePlanCharge.Trial_Agreement_Required__c, ProductRatePlanCharge.TrialableProduct__c, ProductRatePlanCharge.TriggerEvent, ProductRatePlanCharge.Underlying_Product_ID__c, ProductRatePlanCharge.UnitCode__c, ProductRatePlanCharge.UOM, ProductRatePlanCharge.UpdatedById, ProductRatePlanCharge.UpdatedDate, ProductRatePlanCharge.UpToPeriods, ProductRatePlanCharge.UpToPeriodsType, ProductRatePlanCharge.UsageRecordRatingOption, ProductRatePlanCharge.UseDiscountSpecificAccountingCode, ProductRatePlanCharge.User_ID_Required__c, ProductRatePlanCharge.UseTenantDefaultForPriceChange, ProductRatePlanCharge.VertexProduct__c, ProductRatePlanCharge.VertexProductClass__c, ProductRatePlanCharge.WeeklyBillCycleDay, Product.Id, ProductRatePlan.Id FROM ProductRatePlanCharge"
} ],
"useLastCompletedJobQueries" : false,
"encrypted" : "none",
"status" : "error",
"version" : "1.0",
"format" : "CSV",
"name" : "INFA-Query-ProductRatePlanCharge"
}

1 REPLY 1
Highlighted
Master

Re: Error Post Request Payload

Hi @nishant

 

I could not find the direct cause of the error in your query.

By the way, this query seems to get all the fields of ProductRatePlanCharge.

So I will propose. Export ZOQL can use wildcard, so how about running the following query instead of your query?

SELECT *, Product.Id, ProductRatePlan.Id FROM ProductRatePlanCharge

If this query satisfies your requirements, typo may be hiding in the select clause.