Open Support Cases You ma, I might complain about my brother sometimesespecially how he takes up so much of mom's timebut I've decided that he really is a nifty fellow. Check the required fields, field types, node name, and alias are correct.here is my json EinsteinData ManagerLoad Seed Bank Agencies w/Climate DataDATAFLOWLoad Seed Bank Agencies w/Climate DataRun DataflowJSON for 'Load Seed Bank Agencies w/Climate Data'Download JSON{ "Add Temp Class": { "action": "computeExpression", "parameters": { "source": "Filter 2015", "mergeWithSource": true, "computedFields": [ { "defaultValue": "Continental", "name": "TempClass", "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end", "label": "TempClass", "type": "Text" } ] } }, Any help is really helpful.RegardsSri, "Filter Agency Records": { "action": "filter", "parameters": { "filter": "IsAgency:EQ:TRUE", "source": "ID Agency Records" } }, "Load Account": { "action": "sfdcDigest", "parameters": { "fields": [ { "name": "AccountNumber" }, { "name": "Name" }, { "name": "Phone" }, { "name": "ShippingCity" }, { "name": "ShippingCountry" }, { "name": "ShippingPostalCode" }, { "name": "ShippingState" }, { "name": "ShippingStreet" } ], "object": "Account" } }, "Create Seed Bank Agencies": { "action": "sfdcRegister", "parameters": { "name": "Seed Bank Agencies", "alias": "seed_bank_agencies", "source": "Augment TempClass" } }, "Load Climate": { "action": "edgemart", "parameters": { "alias": "Global_Climates" } }, "Add Agency Fields": { "action": "augment", "parameters": { "right_key": [ "AccountNumber" ], "left": "Load Account", "left_key": [ "AccountNumber" ], "right_select": [ "Acres", "Currency", "Latitude", "Longitude", "Region", "SubRegion" ], "right": "Load Agency Detail", "relationship": "AgencyDetail", "operation": "LookupSingleValue" } }, "Filter 2015": { "action": "filter", "parameters": { "filter": "Date_Year:EQ:2015", "source": "Load Climate" } }, "Augment TempClass": { "action": "augment", "parameters": { "right_key": [ "Country" ], "left": "Filter Agency Records", "left_key": [ "ShippingCountry" ], "right_select": [ "Country", "Date", "TempClass", "Temperature" ], "right": "Add Temp Class", "relationship": "Climate", "operation": "LookupSingleValue" } }, "Load Agency Detail": { "action": "edgemart", "parameters": { "alias": "Agency_Detail" } }, "ID Agency Records": { "action": "computeExpression", "parameters": { "source": "Add Agency Fields", "mergeWithSource": true, "computedFields": [ { "name": "IsAgency", "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end", "label": "IsAgency", "type": "Text" } ] } }}CloseSearch nodeshidden, "Add Agency Fields": {"action": "augment","parameters": {"right_key": ["AccountNumber"],"left": "Load Account","left_key": ["AccountNumber"],"right_select": ["Acres","Currency","Latitude","Longitude","Region","SubRegion"I have something additional in "right select", And slightly different saql"name": "IsAgency","saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end","label": "IsAgency","type": "Text", hi, i am getting the following error in challenge six,load seed bank w/climate data dataflow - Something went wrong while executing the Augment TempClass node: Duplicate field TempClass (02K2x000000ZIJLEA4_03C2x000000baEEEAY)i don't see a duplicate,could you help me out.here is my JSON:{ "Load Climate": { "action": "edgemart", "parameters": { "alias": "Global_Climates" } }, "Filter 2015": { "action": "filter", "parameters": { "source": "Load Climate", "filter": "Date_Year:R:2015" } }, "Add TempClass": { "action": "computeExpression", "parameters": { "mergeWithSource": true, "source": "Filter 2015", "computedFields": [ { "type": "Text", "name": "TempClass", "label": "TempClass", "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <=50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end", "defaultValue": "Continental" } ] } }, "Load Seed Bank Agencies": { "action": "edgemart", "parameters": { "alias": "seed_bank_agencies" } }, "Augment TempClass": { "action": "augment", "parameters": { "operation": "LookupSingleValue", "left": "Load Seed Bank Agencies", "relationship": "Climate", "right": "Add TempClass", "left_key": [ "Country" ], "right_key": [ "Country" ], "right_select": [ "TempClass" ] } }, "Create Seed Bank Agencies": { "action": "sfdcRegister", "parameters": { "source": "Augment TempClass", "alias": "seed_bank_agencies", "name": "Seed Bank Agencies" } }}, hmm I have a different left node for augment temp class (left": "Load Seed Bank Agencies"). I hope that you feel inspired. such a silly mistake it was and i was stuck there for long. "Create Seed Bank": {"action": "sfdcRegister","parameters": {"source": "CleanUp","alias": "Seed_Bank","name": "Seed Bank"alias punctuation. R&D, A project with Daddy: My favorite daily process! Trailhead Superbadge: Data Integration Specialist - Forcetalks September 11, 2020 18088 0 Challenge 1 Configure Outbound Application and Integration Security Install the unmanaged package from the prework if you haven't already. This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. I just checked the seed chart flat file, and i could see that Acreage filed itself is not present, so i downloaded the zip file again and found that there is no filed called Acreage in it as well , i found this when i clicked on output fields of Load Seed Chart: edgemart.please let me know if this is the case and if yes how can i fix it? I didn't dig any further once I saw the AccountNumber issue. I think I will have to post in two comments due to the html limit. CRM Analytics Data Preparation Specialist | Salesforce Trailhead Hi there.I made the changes as you suggested and still receiving the same error. { "Add Temp Class": { "action": "computeExpression", "parameters": { "source": "Define Temp Range", "mergeWithSource": true, "computedFields": [ { "defaultValue": "Continental", "name": "TempClass", "saqlExpression": "\"case when Temperature < 25 then \\\"Polar\\\" when Temperature >= 25 and Temperature <= 50 then \\\"Cool\\\" when Temperature >= 51 and Temperature <= 85 then \\\"Continental\\\" when Temperature > 85 then \\\"Tropical\\\" end\"", "label": "TempClass", "type": "Text" } ] } }, "Calculate Acreage": { "action": "computeExpression", "parameters": { "source": "Load Seed Chart", "mergeWithSource": true, "computedFields": [ { "precision": 18, "name": "Acreage", "saqlExpression": "(Seeds_Pound*Spacing)/6272640", "scale": 6, "label": "Acreage", "type": "Numeric" } ] } }, "Create Seed Bank": { "action": "sfdcRegister", "parameters": { "name": "Seed Bank Agencies", "alias": "seed_bank_agencies", "source": "CleanUp" } }, "Load Seed Chart": { "action": "edgemart", "parameters": { "alias": "Seed_Chart" } }, "Augment Temp Class": { "action": "augment", "parameters": { "right_key": [ "TempClass" ], "left": "Add Temp Class", "left_key": [ "TempClass" ], "right_select": [ "TempKey", "TempClass" ], "right": "Load Temp Class Mapping", "relationship": "Climate", "operation": "LookupSingleValue" } }, "Load Temp Class Mapping": { "action": "edgemart", "parameters": { "alias": "Temperature_Classes_Mapping", } }, "CleanUp": { "action": "sliceDataset", "parameters": { "mode": "drop", "source": "Augment Temp Class", "fields": [ { "name": "HighTemp" }, { "name": "LowTemp" } ] } }, "Define Temp Range": { "action": "computeExpression", "parameters": { "source": "Calculate Acreage", "mergeWithSource": true, "computedFields": [ { "defaultValue": "0", "precision": 18, "name": "LowTemp", "saqlExpression": "string_to_number(substr(Temperature, 1, 2))", "scale": 2, "label": "LowTemp", "type": "Numeric" }, { "defaultValue": "0", "precision": 18, "name": "HighTemp", "saqlExpression": "string_to_number(substr(Temperature, -2, 2))", "scale": 2, "label": "HighTemp", "type": "Numeric" } ] } }}. Superbadge-Data-Integration-Specialist/Challenge #5/ProjectRESTService.cls Go to file Cannot retrieve contributors at this time 40 lines (33 sloc) 1.12 KB Raw Blame @RestResource ( urlMapping = '/project/*') global class ProjectRESTService { @HttpPost global static String postProjectData ( String projectRef, String projectName, Apex Specialist SuperBadge 5. "I'm publishing my JSON file just to see what I'm really missing (I would really appreciate if someone knows what's going on), { "Add Temp Class": { "action": "computeExpression", "parameters": { "source": "Filter 2015", "mergeWithSource": true, "computedFields": [ { "defaultValue": "Continental", "name": "TempClass", "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end ", "label": "TempClass", "type": "Text" } ] } }, "Filter Agency Records": { "action": "filter", "parameters": { "filter": "IsAgency:EQ:TRUE", "source": "ID Agency Records" } }, "Load Account": { "action": "sfdcDigest", "parameters": { "fields": [ { "name": "Name" }, { "name": "AccountNumber" }, { "name": "Phone" }, { "name": "ShippingCity" }, { "name": "ShippingCountry" }, { "name": "ShippingState" }, { "name": "ShippingStreet" }, { "name": "ShippingPostalCode" } ], "object": "Account" } }, "Create Seed Bank Agencies": { "action": "sfdcRegister", "parameters": { "rowLevelSecurityFilter": "", "name": "Seed Bank Agencies", "alias": "seed_bank_agencies", "source": "Augment TempClass" } }, "Load Climate": { "action": "edgemart", "parameters": { "alias": "Global_Climates" } }, "Add Agency Fields": { "action": "augment", "parameters": { "right_key": [ "AccountNumber" ], "left": "Load Account", "left_key": [ "AccountNumber" ], "right_select": [ "SubRegion", "Region", "Longitude", "Latitude", "Currency", "Acres" ], "right": "Load Agency Detail", "relationship": "AgencyDetail", "operation": "LookupSingleValue" } }, "Filter 2015": { "action": "filter", "parameters": { "filter": "Date:EQ:2015", "source": "Load Climate" } }, "Augment TempClass": { "action": "augment", "parameters": { "right_key": [ "Country" ], "left": "Filter Agency Records", "left_key": [ "ShippingCountry" ], "right_select": [ "Temperature", "Date", "Country", "TempClass" ], "right": "Add Temp Class", "relationship": "Climate", "operation": "LookupSingleValue" } }, "Load Agency Detail": { "action": "edgemart", "parameters": { "alias": "Agency_Detail" } }, "ID Agency Records": { "action": "computeExpression", "parameters": { "source": "Add Agency Fields", "mergeWithSource": true, "computedFields": [ { "name": "IsAgency", "saqlExpression": "case when \"Phone\" is not null then \"TRUE\" else \"FASLE\" end", "label": "IsAgency", "type": "Text" } ] } }}.
Globus Glacier National Park Tour,
Articles D