Apex Code Development You need to sign in to do that
Don't have an account?
Rahul Sangwan7341 Wave Analytics (Edgemart) Error: Field [Payment_Amount] is missing in 1 out of 2 inputs Field.
{
"Extract_PricebookEntry": {
"action": "sfdcDigest",
"parameters": {
"SFDCtoken": "SFDCtoken",
"maxAllowedOffset": 1500,
"fields": [
{
"name": "Id"
},
{
"name": "Product2Id"
}
],
"concurrentBatches": 12,
"object": "PricebookEntry"
}
},
"augment_Payment__c_Opportunity_2": {
"action": "augment",
"parameters": {
"right_key": [
"Id"
],
"left": "sfdcDigest_Payment__c_2",
"left_key": [
"Opportunity__c"
],
"right_select": [
"Name",
"Id",
"AccountId",
"OwnerId"
],
"right": "sfdcDigest_Opportunity_2",
"relationship": "Opportunity__c"
}
},
"augment_Payment__c_Opportunity_0": {
"action": "augment",
"parameters": {
"right_key": [
"Id"
],
"left": "sfdcDigest_Payment__c_0",
"left_key": [
"Opportunity__c"
],
"right_select": [
"Amount",
"IsClosed",
"Name",
"Id",
"AccountId",
"OwnerId"
],
"right": "sfdcDigest_Opportunity_0",
"relationship": "Opportunity__c"
}
},
"sfdcDigest_Payment__c_0": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "Donor_Code__c"
},
{
"name": "Name"
},
{
"name": "Payment_Amount__c"
},
{
"name": "Id"
},
{
"name": "Opportunity__c"
}
],
"object": "Payment__c"
}
},
"sfdcDigest_User": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "IsActive"
},
{
"name": "Name"
},
{
"name": "Id"
}
],
"object": "User"
}
},
"Join_OpportunityLineItemPricebookEntry": {
"action": "augment",
"parameters": {
"right_key": [
"Id"
],
"left_key": [
"PricebookEntryId"
],
"left": "Extract_OpportunityLineItem",
"right_select": [
"Product2Id"
],
"right": "Extract_PricebookEntry",
"relationship": "Pricebook"
}
},
"Extract_Opportunity": {
"action": "sfdcDigest",
"parameters": {
"SFDCtoken": "SFDCtoken",
"maxAllowedOffset": 1500,
"fields": [
{
"name": "Id"
},
{
"name": "AccountId"
},
{
"name": "OwnerId"
},
{
"name": "Name"
},
{
"name": "StageName"
},
{
"name": "LeadSource"
},
{
"name": "IsWon"
},
{
"name": "Type"
},
{
"name": "IsClosed"
},
{
"name": "ForecastCategory"
},
{
"name": "ForecastCategoryName"
},
{
"name": "CreatedDate"
},
{
"name": "CloseDate"
},
{
"name": "Amount"
},
{
"name": "CreatedById"
}
],
"concurrentBatches": 12,
"object": "Opportunity"
}
},
"Join_AccountOwner": {
"action": "augment",
"parameters": {
"right_key": [
"Id"
],
"left_key": [
"OwnerId"
],
"left": "Extract_Account",
"right_select": [
"Name",
"Username"
],
"right": "Extract_User",
"relationship": "Owner",
"operation": "LookupMultiValue"
}
},
"sfdcDigest_Account": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "Name"
},
{
"name": "AccountSource"
},
{
"name": "Type"
},
{
"name": "Id"
}
],
"object": "Account"
}
},
"augment_User": {
"action": "augment",
"parameters": {
"right_key": [
"Id"
],
"left": "augment_Case_Account",
"left_key": [
"OwnerId"
],
"right_select": [
"IsActive",
"Name"
],
"right": "sfdcDigest_User",
"relationship": "OwnerId"
}
},
"Extract_Product": {
"action": "sfdcDigest",
"parameters": {
"SFDCtoken": "SFDCtoken",
"maxAllowedOffset": 1500,
"fields": [
{
"name": "Id"
},
{
"name": "ProductCode"
},
{
"name": "Name"
},
{
"name": "Family"
}
],
"concurrentBatches": 12,
"object": "Product2"
}
},
"sfdcDigest_Payment__c_2": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "Donor_Code__c"
},
{
"name": "Payment_Amount__c"
},
{
"name": "Id"
},
{
"name": "Opportunity__c"
}
],
"object": "Payment__c"
}
},
"Extract_User": {
"action": "sfdcDigest",
"parameters": {
"SFDCtoken": "SFDCtoken",
"chunkSize": 1500,
"maxAllowedOffset": 1500,
"fields": [
{
"name": "Id"
},
{
"name": "Username"
},
{
"name": "Name"
},
{
"name": "UserRoleId"
},
{
"name": "ManagerId"
}
],
"concurrentBatches": 12,
"object": "User"
}
},
"sfdcDigest_User_1": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "Name"
},
{
"name": "Id"
}
],
"object": "User"
}
},
"register_Payment with Donor_0": {
"action": "sfdcRegister",
"parameters": {
"name": "Payment with Donor",
"alias": "Payment_with_Donor",
"source": "augment_User_0"
}
},
"sfdcDigest_User_2": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "Id"
},
{
"name": "Name"
}
],
"object": "User"
}
},
"Join_OpportunityOwner": {
"action": "augment",
"parameters": {
"right_key": [
"Id"
],
"left_key": [
"OwnerId"
],
"left": "Join_OpportunityAccount",
"right_select": [
"Name",
"Username"
],
"right": "Extract_User",
"relationship": "Owner",
"operation": "LookupMultiValue"
}
},
"sfdcDigest_User_0": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "Name"
},
{
"name": "Id"
}
],
"object": "User"
}
},
"Join_OpportunityLineItemPricebookEntryProduct": {
"action": "augment",
"parameters": {
"right_key": [
"Id"
],
"left_key": [
"Pricebook.Product2Id"
],
"left": "Join_OpportunityLineItemPricebookEntry",
"right_select": [
"ProductCode",
"Name",
"Family"
],
"right": "Extract_Product",
"relationship": "Product"
}
},
"Register_OpportunityProducts": {
"action": "sfdcRegister",
"parameters": {
"SFDCtoken": "SFDCtoken",
"rowLevelSecurityFilter": "",
"name": "Products Opportunities",
"alias": "products_opportunities",
"source": "Join_OpportunityOpportunityLineItemPricebookEntryProduct"
}
},
"augment_Account_User_1": {
"action": "augment",
"parameters": {
"right_key": [
"Id"
],
"left": "sfdcDigest_Account_1",
"left_key": [
"OwnerId"
],
"right_select": [
"Name",
"Id"
],
"right": "sfdcDigest_User_1",
"relationship": "OwnerId"
}
},
"sfdcDigest_Account_0": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "Unique_Id__c"
},
{
"name": "Name"
},
{
"name": "Id"
}
],
"object": "Account"
}
},
"Join_OpportunityAccount": {
"action": "augment",
"parameters": {
"right_key": [
"Id"
],
"left_key": [
"AccountId"
],
"left": "Extract_Opportunity",
"right_select": [
"Name",
"Type",
"Industry",
"BillingCountry",
"BillingState",
"AccountSource",
"OwnerId",
"Owner.Name"
],
"right": "Join_AccountOwner",
"relationship": "Account",
"operation": "LookupMultiValue"
}
},
"sfdcDigest_Account_2": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "Name"
},
{
"name": "Unique_Id__c"
},
{
"name": "Id"
}
],
"object": "Account"
}
},
"sfdcDigest_Account_1": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "Name"
},
{
"name": "Unique_Id__c"
},
{
"name": "OwnerId"
}
],
"object": "Account"
}
},
"register_Donor Data_1": {
"action": "sfdcRegister",
"parameters": {
"name": "Donor Data",
"alias": "Donor_Data",
"source": "augment_Account_User_1"
}
},
"augment_Account_2": {
"action": "augment",
"parameters": {
"right_key": [
"Id"
],
"left": "augment_Payment__c_Opportunity_2",
"left_key": [
"Opportunity__c.AccountId"
],
"right_select": [
"Name",
"Unique_Id__c",
"Id"
],
"right": "sfdcDigest_Account_2",
"relationship": "Opportunity__c.AccountId"
}
},
"augment_Account_0": {
"action": "augment",
"parameters": {
"right_key": [
"Id"
],
"left": "augment_Payment__c_Opportunity_0",
"left_key": [
"Opportunity__c.AccountId"
],
"right_select": [
"Unique_Id__c",
"Name"
],
"right": "sfdcDigest_Account_0",
"relationship": "Opportunity__c.AccountId"
}
},
"augment_User_2": {
"action": "augment",
"parameters": {
"right_key": [
"Id"
],
"left": "augment_Account_2",
"left_key": [
"Opportunity__c.OwnerId"
],
"right_select": [
"Id",
"Name"
],
"right": "sfdcDigest_User_2",
"relationship": "Opportunity__c.OwnerId"
}
},
"augment_Case_Account": {
"action": "augment",
"parameters": {
"right_key": [
"Id"
],
"left": "sfdcDigest_Case",
"left_key": [
"AccountId"
],
"right_select": [
"Name",
"AccountSource",
"Type"
],
"right": "sfdcDigest_Account",
"relationship": "AccountId"
}
},
"augment_User_0": {
"action": "augment",
"parameters": {
"right_key": [
"Id"
],
"left": "augment_Account_0",
"left_key": [
"Opportunity__c.OwnerId"
],
"right_select": [
"Name",
"Id"
],
"right": "sfdcDigest_User_0",
"relationship": "Opportunity__c.OwnerId"
}
},
"Extract_Account": {
"action": "sfdcDigest",
"parameters": {
"SFDCtoken": "SFDCtoken",
"fields": [
{
"name": "Id"
},
{
"name": "Name"
},
{
"name": "OwnerId"
},
{
"name": "AccountSource"
},
{
"name": "Type"
},
{
"name": "Industry"
},
{
"name": "BillingCountry"
},
{
"name": "BillingState"
},
{
"name": "CreatedDate"
},
{
"name": "LastModifiedDate"
}
],
"object": "Account"
}
},
"Extract_OpportunityLineItem": {
"action": "sfdcDigest",
"parameters": {
"SFDCtoken": "SFDCtoken",
"maxAllowedOffset": 1500,
"fields": [
{
"name": "OpportunityId"
},
{
"name": "ProductCode"
},
{
"name": "ListPrice"
},
{
"name": "Quantity"
},
{
"name": "TotalPrice"
},
{
"name": "PricebookEntryId"
}
],
"concurrentBatches": 12,
"object": "OpportunityLineItem"
}
},
"Join_OpportunityOpportunityLineItemPricebookEntryProduct": {
"action": "augment",
"parameters": {
"right_key": [
"Id"
],
"left_key": [
"OpportunityId"
],
"left": "Join_OpportunityLineItemPricebookEntryProduct",
"right_select": [
"Name",
"StageName",
"CloseDate",
"IsWon",
"Type",
"IsClosed",
"LeadSource",
"ForecastCategory",
"ForecastCategoryName",
"CreatedDate",
"AccountId",
"Account.Name",
"Account.OwnerId",
"Account.Type",
"Account.Industry",
"Account.BillingCountry",
"Account.BillingState",
"Account.AccountSource",
"Account.Owner.Name",
"OwnerId",
"Owner.Name"
],
"right": "Join_OpportunityOwner",
"relationship": "Opportunity"
}
},
"sfdcDigest_Case": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "Id"
},
{
"name": "CaseNumber"
},
{
"name": "Origin"
},
{
"name": "Reason"
},
{
"name": "Type"
},
{
"name": "AccountId"
},
{
"name": "OwnerId"
}
],
"object": "Case"
}
},
"sfdcDigest_Opportunity_2": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "Name"
},
{
"name": "Id"
},
{
"name": "AccountId"
},
{
"name": "OwnerId"
}
],
"object": "Opportunity"
}
},
"register_Salesforce Payments_2": {
"action": "sfdcRegister",
"parameters": {
"name": "Salesforce Payments",
"alias": "Salesforce_Payments",
"source": "augment_User_2"
}
},
"register_Cases with Accounts": {
"action": "sfdcRegister",
"parameters": {
"name": "Cases with Accounts",
"alias": "Cases_with_Accounts",
"source": "augment_User"
}
},
"sfdcDigest_Opportunity_0": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "Amount"
},
{
"name": "IsClosed"
},
{
"name": "Name"
},
{
"name": "Id"
},
{
"name": "AccountId"
},
{
"name": "OwnerId"
}
],
"object": "Opportunity"
}
},
"Register_Opportunity": {
"action": "sfdcRegister",
"parameters": {
"SFDCtoken": "SFDCtoken",
"rowLevelSecurityFilter": "",
"name": "Opportunities",
"alias": "opportunities",
"source": "Join_OpportunityOwner"
}
},
"New_Payment_Ext": {
"action": "edgemart",
"parameters": {
"alias": "New_Payment_CSV"
}
},
"New_Payment_SF": {
"action": "edgemart",
"parameters": {
"alias": "Salesforce_Payments"
}
},
"Append_Payments_All": {
"action": "append",
"parameters": {
"sources": [
"New_Payment_Ext",
"New_Payment_SF"
]
}
}
}
| Failed |
| Something went wrong while executing the Append_Payments_All node: Field [Payment_Amount] is missing in 1 out of 2 inputs Field [Opportunity__c.AccountId.Name] is missing in 1 out of 2 inputs Field [Opportunity__c.OwnerId.Name] is missing in 1 out of 2 inputs Field [Donor_Code__c] is missing in 1 out of 2 inputs Field [Opportunity_c_AccountId_Name] is missing in 1 out of 2 inputs Field [Opportunity_c_OwnerId] is missing in 1 out of 2 inputs Field [Opportunity__c.OwnerId] is missing in 1 out of 2 inputs Field [Opportunity_c_IsClosed] is missing in 1 out of 2 inputs Field [Opportunity_c_OwnerId_Name] is missing in 1 out of 2 inputs Field [Opportunity__c] is missing in 1 out of 2 inputs Field [Name] is missing in 1 out of 2 inputs Field [Opportunity__c.Id] is missing in 1 out of 2 inputs Field [Opportunity_c_Name] is missing in 1 out of 2 inputs Field [Opportunity_c_OwnerId_Id] is missing in 1 out of 2 inputs Field [Donor_Code] is missing in 1 out of 2 inputs Field [Opportunity__c.AccountId.Unique_Id__c] is missing in 1 out of 2 inputs Field [Opportunity_c_Amount] is missing in 1 out of 2 inputs Field [Opportunity_c_AccountId] is missing in 1 out of 2 inputs Field [Payment_Amount__c] is missing in 1 out of 2 inputs Field [Id] is missing in 1 out of 2 inputs Field [Opportunity] is missing in 1 out of 2 inputs Field [Payment_Name] is missing in 1 out of 2 inputs Field [Opportunity__c.Name] is missing in 1 out of 2 inputs Field [Opportunity__c.Amount] is missing in 1 out of 2 inputs Field [Opportunity__c.OwnerId.Id] is missing in 1 out of 2 inputs Field [Opportunity__c.IsClosed] is missing in 1 out of 2 inputs Field [Opportunity_c_AccountId_Unique_Id__c] is missing in 1 out of 2 inputs Field [Record_ID] is missing in 1 out of 2 inputs Field [Opportunity_c_Id] is missing in 1 out of 2 inputs Field [Opportunity__c.AccountId] is missing in 1 out of 2 inputs (02K7F000000l59MUAQ_03C7F000000nK3dUAE) I checked the fileds of my CSV and Excel they are same, in name and sequence. I am not getting any idea, why i am getting this error. |