To complete the challenges, you need to pre-populate the Account object with data associated with this superbadge. Getting the following warning when running the dataflow:Load Seed Bank Agencies w/Climate DataThe dataflow was completed, but the LookupSingleValue node didn't augment any columns. https://docs.google.com/document/d/1RaNsOtQZlsL_yVTd0NWkox9kpyV1LLJ60fWBEVQwsLI/edit?usp=sharing. Salesforce Trailhead Superbadge 'Data Integration Specialist' Data Integration Specialist is one of the superbadges of Salesforce trailhead (A New Approach to Learning Salesforce). It's free to sign up and bid on jobs. Yes! { "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" } ] } }}. Data integration specialist superbadge solution. "name": "Create Seed Bank" - This is incorrect. thanks.~. Now, Check the challenge Challenge 2- (Configure outbound application and integration Security) :- Step-1:- Install the unlocked package with package id: 04t6g000008arl1AAA (For All Users). Salesforce Trailhead Superbadge 'Data Integration Specialist' Data Integration Specialist is one of the superbadges of Salesforce trailhead (A New Approach to Learning Salesforce). upsert directly against the ProjectRef__c external id field, https://developer.salesforce.com/forums/?id=9060G000000I526QAC, https://developer.salesforce.com/forums/?id=9060G000000I56rQAC. I haven't done that superbadge yet! Which of the Lenses are you working to create? "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" } ] } }}I had to copy in two comments, it was to large. Copyright 2000-2022 Salesforce, Inc. All rights reserved. Confirm the node name matches the name as described in the challenge. Data Integration Specialist Superbadge - Step 7 I'm getting an error message when triggering the SOAP call from the UI via record update: System.CalloutException: IO Exception: External server did not return any content When I import the WSDL into SOAP UI and send the same package body, I receive this message: HTTP /1.1 500 Server: Cowboy This is regarding Challenge 6. Thanks for your help. Why the change of heart? Check the required fields, field types, node name, and alias are correct. Hi,Thanks for your reply. hmm Could you post the json for the dataflow? },"Augment TempClass": {"action": "augment","parameters": {"right_key": ["Country"],"left": "Load Seed Bank Agencies","left_key": ["ShippingCountry"],"right_select": ["TempClass"My "left": "Load Seed Bank Agencies", is different plus several additional right select items. Can you please let me know what was the root cause? { "Calculate Acreage": { "action": "computeExpression", "parameters": { "source": "Seed Chart", "mergeWithSource": true, "computedFields": [ { "precision": 18, "name": "Acreage", "saqlExpression": " (Seeds_Pound*Spacing)/6272640", "scale": 6, "label": "Acreage", "type": "Numeric" } ] } }, "Seed Bank": { "action": "sfdcRegister", "parameters": { "rowLevelSecurityFilter": "", "name": "seedbank", "alias": "seedbank", "source": "Calculate Acreage" } }, "Seed Chart": { "action": "edgemart", "parameters": { "alias": "Seed_Chart" } }}, },"Seed Bank": {"action": "sfdcRegister","parameters": {"rowLevelSecurityFilter": "","name": "seedbank","alias": "seedbank","source": "Calculate Acreage"Wrong alias and name, Hi allI am having a really hard time with Step 6. Rated Accounts by State The record count for state and account rating are automatically added. * Email Alerts I needed the Email Alerts set up before I could create either the process or the approval. Check the challenge and confirm the node name and required fields.I have deleted and recreated the dataset and the dataflow; no luck.Thanks!Karen. ", Hey! Hint - The TempClass formula is different for each of the dataflows. Here is my Json in 2 messages if someone can help : { "Add Temp Class": { "action": "computeExpression","parameters": { "source": "Filter 2015", "mergeWithSource": true, "computedFields": [ { "defaultValue": "Continental", "name": "TempClass", "saqlExpression": "case \nwhen Temperature < 25 then \"Polar\" \nwhen Temperature >= 25 and Temperature <= 50 then \"Cool\" \nwhen Temperature >= 51 and Temperature <= 85 then \"Continental\" \nwhen Temperature > 85 then \"Tropical\" \nend", "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": "Phone" }, { "name": "ShippingCity" }, { "name": "ShippingCountry" }, { "name": "ShippingPostalCode" }, { "name": "ShippingStreet" }, { "name": "ShippingState" }, { "name": "AccountNumber" } ], "object": "Account" } }, 2nd part of Json : "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" } }, "Load Agency detail": { "action": "edgemart", "parameters": { "alias": "Agency_Detail" } }, "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": [ "Temperature", "Date", "TempClass", "Country" ], "right": "Add Temp Class", "relationship": "Climate", "operation": "LookupSingleValue" } }, "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" } ] } }}Thanks for help, Hi, I have a problem with the step 6: When I run the DataflowLoad Seed Bank Agencies w/Climate Data it give me this error: Something went wrong while executing the Augment TempClass node: Right select in augment node must properly refer to the right input column. such a silly mistake it was and i was stuck there for long. I've added at the right select AccountNumber at Add Agency Fields and propagated, but still it isn't work.. this is blowing my mind! Please check your work. 'Load Seed Bank Agencies w/Climate Data'{ "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": "AccountNumber" }, { "name": "Name" }, { "name": "ShippingCity" }, { "name": "ShippingCountry" }, { "name": "ShippingPostalCode" }, { "name": "ShippingState" }, { "name": "ShippingStreet" }, { "name": "Phone" } ], "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:R:2015", "source": "Load Climate" } }, "Augment TempClass": { "action": "augment", "parameters": { "right_key": [ "Country" ], "left": "Filter Agency Records", "left_key": [ "ShippingCountry" ], "right_select": [ "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 \"FALSE\" end", "label": "IsAgency", "type": "Text" } ] } }}Close. 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"). Step 6 is tricky! Please check your work.Many thanks. still i'm facing the same issue. when i validate my step 6, i checked with existing suggestion via above posts i have corrected alias name and left key and right key for same name nothing worked and struck with from some now, please let me know what else i am missing !thankskiran. Report Modifications: Sales Two words: Filter Logic Support If you get this errortry stacking to 100% and make sure that you have a "horizontal" style chart. If someone could be so kind to support, that would really be helpful.Thanks a lot. Various trademarks held by their respective owners. No Even after that it is not working it says We can't find the 'Load Seed Chart' node in the dataflow.