Challenge 5: Test callout logic. I just tried that and it I still keep getting this error. 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 Rated Accounts by State The record count for state and account rating are automatically added. #dataintegrationspecialist##techinvisible#superbadgeagentDo follow on instagram for complete superbadge access :https://www.instagram.com/tech_invisible/ No. Either the node didn't find any matches, or a join key contains only null values. Either the node didn't find any matches, or a join key contains only null values." Configure a named credential and remote site according to the specifications outlined in the business requirements. i have completed my step 7 already but could not proceed because of step 6 issues. can anyone help me out in this? Thanks in Advance (split in 2 for upload reasons){ "Load Temp Class Mapping": { "action": "edgemart", "parameters": { "alias": "Temperature_Classes_Mapping" } }, "Load Seed Bank": { "action": "edgemart", "parameters": { "alias": "seed_bank" } }, "Define Temp Range": { "action": "computeExpression", "parameters": { "mergeWithSource": true, "source": "Load Seed Bank", "computedFields": [ { "type": "Numeric", "name": "lowTemp", "label": "lowTemp", "saqlExpression": "string_to_number(substr(Temperature,1,2))", "precision": 18, "scale": 6 }, { "type": "Numeric", "name": "highTemp", "label": "highTemp", "saqlExpression": "string_to_number(substr(Temperature,-2,2))", "precision": 18, "scale": 6 } ] } }, "Add Temp Class": { "action": "computeExpression", "parameters": { "mergeWithSource": true, "source": "Define Temp Range", "computedFields": [ { "type": "Text", "name": "TempClass", "label": "TempClass", "saqlExpression": "\"case \\nwhen lowTemp < 25 and highTemp < 25 then \\\"Polar\\\" \\nwhen lowTemp >= 25 and lowTemp <= 50 and highTemp >= 25 and highTemp <= 50 then \\\"Cool\\\"\\nwhen lowTemp >= 51 and lowTemp <= 85 and highTemp >= 51 and highTemp <= 85 then \\\"Continental\\\"\\nwhen lowTemp > 85 and highTemp > 85 then \\\"Tropical\\\"\\nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 50) then \\\"Polar-Cool\\\" \\nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 85) then \\\"Polar-Cool-Continental\\\" \\nwhen lowTemp < 25 and highTemp > 85 then \\\"Polar-Cool-Continental-Tropical\\\" \\nwhen (lowTemp >= 25 and lowTemp <= 50) and (highTemp >= 51 and highTemp <= 85) then \\\"Cool-Continental\\\" \\nwhen (lowTemp >= 25 and lowTemp <= 50) and highTemp >= 85 then \\\"Cool-Continental-Tropical\\\" \\nwhen (lowTemp >= 51 and lowTemp <= 85) and highTemp > 85 then \\\"Continental-Tropical\\\" \\nend\"" } ] } }, Second part:"CleanUp": { "action": "sliceDataset", "parameters": { "mode": "drop", "fields": [ { "name": "highTemp" }, { "name": "lowTemp" }, { "name": "TempClass" } ], "source": "Augment Temp Class" } }, "Create Seed Bank": { "action": "sfdcRegister", "parameters": { "source": "CleanUp", "alias": "seed_bank", "name": "Seed Bank" } }, "Augment Temp Class": { "action": "augment", "parameters": { "operation": "LookupSingleValue", "left": "Add Temp Class", "left_key": [ "TempClass" ], "relationship": "Climate", "right": "Load Temp Class Mapping", "right_key": [ "TempKey" ], "right_select": [ "TempClass" ] } }}, Following error:Challenge Not yet complete here's what's wrong:We can't validate the 'Create Seed Bank Agencies' node was created correctly. I was able to complete Data Preparation Super badge, now I am doing Einstein Analytics and Discovery Insights Specialist and stuck at step # 3 (Calculate Subscriber Acquisition Costs)Challenge Not yet complete here's what's wrong:We can't confirm the Subscriber Revenue chart is filtering by the Tenure Length toggle. thanks.~. After you've imported the Account object, you'll be ready to tackle the challenges. Confirm the node name matches the name as described in the challenge. When you start a create a new report, simply click to start with a clean screen. I have created lens for Agency Temp Class, it has Continental 155, Polar 120 and Cool 66 based on Seed Bank Agencies Data Set.Another lens Seed Bank Temp Class based on Seed Bank Data Set has Cool-Continental-Tropical 3Continental-Tropical 2Cool-Continental 2Continental 1Cool 1. I would show the attempts but reddit wont allow for screenshots. I don't understand what you mean. Thank you , please find my Json file , with the html limits i will be posting in 2 comments{ "Add Temp Class": { "action": "computeExpression", "parameters": { "source": "Define Temp Range", "mergeWithSource": true, "computedFields": [ { "name": "TempClass", "saqlExpression": "\"case \\nwhen lowTemp < 25 and highTemp < 25 then \\\"Polar\\\" \\nwhen lowTemp >= 25 and lowTemp <= 50 and highTemp >= 25 and highTemp <= 50 then \\\"Cool\\\"\\nwhen lowTemp >= 51 and lowTemp <= 85 and highTemp >= 51 and highTemp <= 85 then \\\"Continental\\\"\\nwhen lowTemp > 85 and highTemp > 85 then \\\"Tropical\\\"\\nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 50) then \\\"Polar-Cool\\\" \\nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 85) then \\\"Polar-Cool-Continental\\\" \\nwhen lowTemp < 25 and highTemp > 85 then \\\"Polar-Cool-Continental-Tropical\\\" \\nwhen (lowTemp >= 25 and lowTemp <= 50) and (highTemp >= 51 and highTemp <= 85) then \\\"Cool-Continental\\\" \\nwhen (lowTemp >= 25 and lowTemp <= 50) and highTemp >= 85 then \\\"Cool-Continental-Tropical\\\" \\nwhen (lowTemp >= 51 and lowTemp <= 85) and highTemp > 85 then \\\"Continental-Tropical\\\" \\nend\"", "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", "alias": "seed_bank", "source": "CleanUp" } }, "Load Seed Chart": { "action": "edgemart", "parameters": { "alias": "Seed_Chart" } }, "Augment Temp Class": { "action": "augment", "parameters": { "right_key": [ "TempClass" ], "left": "Load Temp Class Mapping", "left_key": [ "TempClass" ], "right_select": [ "Acreage", "hightemp", "Lifecycle", "lowtemp", "Quantity_Pounds", "Seed", "Seeds_Pound", "Seed_ID", "Seed_Type", "Spacing", "TempClass", "Temperature" ], "right": "Add Temp Class", "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": "TempClass" }, { "name": "TempKey" }, { "name": "Climate.lowtemp" }, { "name": "Climate.hightemp" } ] } }, "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" } ] } }}. Thanks a lot! Check the required fields, field types, node name, and alias are correct. Yes! Message: 550: To use null dimensions or date filters, you need API version 51 or higher. If you are up to a challenge- I'd do the Process Automation Specialist. Hi I am completely new this superbadges. In the superbadge there's no indication of what naming convention to follow. thanks a lot. "left_key": ["TempKey"],"right_key": ["TempClass"I think this is the issue. Please check your work. )https://developer.salesforce.com/forums/?id=9060G0000005d3yQAA ---> This thread was very heplful! "Augment TempClass": { "action": "augment", "parameters": { "left": "Filter 2015", "right": "Add Temp Class", "relationship": "Climate", "operation": "LookupSingleValue", "left_key": [ "Country" ], "right_key": [ "Country" ], "right_select": [ "TempClass", "Country", "Date", "Temperature"This Worked. Confirm the node name matches the name as described in the challenge.Here is the JSON{ "Load Seed Chart": { "action": "edgemart", "parameters": { "alias": "Load_Seed_Chart" } }, "Calculate Acreage": { "action": "computeExpression", "parameters": { "mergeWithSource": true, "source": "Load Seed Chart", "computedFields": [ { "type": "Numeric", "precision": 18, "scale": 6, "saqlExpression": " (Seeds_Pound*Spacing)/6272640", "name": "Acreage", "label": "Acreage" } ] } }, "Create Seed Bank": { "action": "sfdcRegister", "parameters": { "alias": "CreateSeedBank", "name": "CreateSeedBank", "source": "Calculate Acreage" } }}, "Load Seed Chart": {"action": "edgemart","parameters": {"alias": "Load_Seed_Chart"- Change the alias name to "Seed_Chart" - Don't ask me why. :) "Create Seed Bank": {"action": "sfdcRegister","parameters": {"alias": "CreateSeedBank","name": "CreateSeedBank","source": "Calculate Acreage"- Change Name and Alias name. Hi Rebecca,in #6 for building Seed Bank Temp Class lens, they mentioned the dataset as " Seed Bank" but from the zip i do not see any flat file with that name, i could see only seed chart and seed bank orders please let me know which file i need to upload for dataset? Check the required fields, field types, node name, and alias are correct.Posting json in 2 parts{ "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": "Phone" }, { "name": "ShippingCity" }, { "name": "ShippingCountry" }, { "name": "ShippingPostalCode" }, { "name": "ShippingState" }, { "name": "ShippingStreet" } ], "object": "Account" } }, "Augment Temp Class": { "action": "augment", "parameters": { "right_key": [ "Country" ], "left": "Filter Agency Records", "left_key": [ "ShippingCountry" ], "right_select": [ "Country", "Date", "Temperature", "TempClass" ], "right": "Add Temp Class", "relationship": "Climate", "operation": "LookupSingleValue" } }, "Create Seed Bank Agencies": { "action": "sfdcRegister", "parameters": { "name": "Seed Bank Agencies", "alias": "seed_bank_agencies", "source": "Augment Temp Class" } }, "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": [ "Currency", "Acres", "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" } }, "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\n", "label": "IsAgency", "type": "Text" } ] } }}, "Add Agency Fields": {"action": "augment","parameters": {"right_key": ["AccountNumber"],"left": "Load Account","left_key": ["AccountNumber"],"right_select": ["Currency","Acres","Latitude","Longitude","Region","SubRegion"Missing something here. Start by uploading the dataset then create the dataflow. He laughs when I poke his nose and tries to take toys out of my hand. I hope that you feel inspired. },"Add Agency Fields": {"action": "augment","parameters": {"right_key": ["AccountNumber"],"left": "Load Account","left_key": ["AccountNumber"],"right_select": ["Acres","Currency","Latitude","Longitude","Region","SubRegion"One field is missing. Thanks for your help. { "Add Temp Class": { "action": "computeExpression", "parameters": { "source": "Define Temp Range", "mergeWithSource": true, "computedFields": [ { "name": "TempClass", "saqlExpression": "\"case \\nwhen lowTemp < 25 and highTemp < 25 then \\\"Polar\\\" \\nwhen lowTemp >= 25 and lowTemp <= 50 and highTemp >= 25 and highTemp <= 50 then \\\"Cool\\\"\\nwhen lowTemp >= 51 and lowTemp <= 85 and highTemp >= 51 and highTemp <= 85 then \\\"Continental\\\"\\nwhen lowTemp > 85 and highTemp > 85 then \\\"Tropical\\\"\\nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 50) then \\\"Polar-Cool\\\" \\nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 85) then \\\"Polar-Cool-Continental\\\" \\nwhen lowTemp < 25 and highTemp > 85 then \\\"Polar-Cool-Continental-Tropical\\\" \\nwhen (lowTemp >= 25 and lowTemp <= 50) and (highTemp >= 51 and highTemp <= 85) then \\\"Cool-Continental\\\" \\nwhen (lowTemp >= 25 and lowTemp <= 50) and highTemp >= 85 then \\\"Cool-Continental-Tropical\\\" \\nwhen (lowTemp >= 51 and lowTemp <= 85) and highTemp > 85 then \\\"Continental-Tropical\\\" \\nend\"", "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", "alias": "seed_bank", "source": "CleanUp" } }, "Load Seed Chart": { "action": "edgemart", "parameters": { "alias": "Seed_Chart" } }, "Augment Temp Class": { "action": "augment", "parameters": { "left": "Load Temp Class Mapping", "right": "Add Temp Class", "relationship": "Climate", "operation": "LookupSingleValue", "left_key": [ "TempKey" ], "right_key": [ "TempClass" ], "right_select": [ "Acreage", "hightemp", "Lifecycle", "lowtemp", "Quantity_Pounds", "Seed", "Seeds_Pound", "Seed_ID", "Seed_Type", "Spacing", "TempClass", "Temperature" ] } }, "Load Temp Class Mapping": { "action": "edgemart", "parameters": { "alias": "Temperature_Classes_Mapping" } }, "CleanUp": { "action": "sliceDataset", "parameters": { "mode": "drop", "source": "Augment Temp Class", "fields": [ { "name": "TempClass" }, { "name": "TempKey" }, { "name": "Climate.lowtemp" }, { "name": "Climate.hightemp" } ] } }, "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 Challenge 2 I am trying to register Configure Org Registration where I have to use a custom Heroku app to register my org. Can you elaborate? Trailhead Superbadge: Data Integration Specialist Challenge 1 Configure Outbound Application and Integration Security Install the unmanaged package from the prework if you haven't already. Hey,Hope by this time you have got your answer if not,Please change the alias you will get through challenge 6. If you encounter this error.. You are, perhaps, taking the instructions too literally and need to tweak the formula. i tried switching them and the dataflow was successful. Hi Trailhead Baby,Please help me. The trickiest part is the formulas for Definie Temp Range and Add TempClass. That is against Trailhead's terms of use. upsert directly against the ProjectRef__c external id field, https://developer.salesforce.com/forums/?id=9060G000000I526QAC, https://developer.salesforce.com/forums/?id=9060G000000I56rQAC. !I can't copy here all the code, so I have copy in Gdrive. Check the required fields, field types, node name, and alias are correct. However, if I test my code from workbench, it works correctly. :(, {"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"I see an issue with the SAQL, Hi, I'm stuck at step 6 Before focus, I have: Polar 93, Continental 91, Cool 42. There is not a field named Acreage in the zip file - It is a field you create by calculation within the data flow. Hi , Load Seed Bank w/Temperature Classification when ran ,getting an error like below" The dataflow was completed, but the LookupSingleValue node didn't augment any columns. "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. hmm Could you post the json for the dataflow? Im not sure were to start. Processes. Hint: You can't match on a field that isnt' selected for both data sets. Modified 2 months ago. Appreciated! A tag already exists with the provided branch name. I have the same nodes as you, but I dont understand how you are supposed to multi join or the two nodes before that. This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. I'm happy to look at what you have and make suggestions. Thank you so much Rebeca, My step 6 is resolved finally today. Challenge 2: Synchronize Salesforce data with an external system. When I made mistakes, I simply reverted to the last saved version. If you are short on time, start around the 20 minute mark. Step 5 - A quiz. here's what's wrong: How frustrating! I enjoy playing on Trailhead, taking long walks with mommy, watching the Florida Gators with daddy, and chasing my two dogs. "Create Seed Bank": {"action": "sfdcRegister","parameters": {"source": "Calculate Acreage","alias": "Seed Bank","name": "Seed_Bank"Wrong alias and name. First of all , thanks for prompt reply. I have the same nodes as you. Step 6 is tricky! Thanks! Salesforce Data Analytics let us help you become a data driven organization and ensure your data is working hard for your business, This includes implementionSalesforce consulting companiesSalesforce ServicesStaff augmentation companiesSalesforce integration companiesSalesforce Implementation servicesSalesforce Health CheckSalesforce DevOpsManaged project services. Import the Agency Data.txt file into the Account object in your CRM Analytics Developer Edition org. let me know what i am missing here. @trailhead baby,i just updated one alias name in above postsfrom :::"name": "Seed Bank","alias": "seed_bank"to:::"name": "Seed Bank","alias": "Seed_Bank"and re ran the dataflow still have the same old issue no progress ! A huge thank you to Jocelyn Fennewald , Salesforce MVP, for pointing out the "remove all columns" option within the report creator. Salesforce: Trailhead : Data Integration Specialist Challenge 5Helpful? I think I will have to post in two comments due to the html limit. @Shruthi, did you got the issue fixed? (02K7R000000pt8bUAA_03C7R000004QOLfUAO)I send the Json of this nodeNode Name Augment TempClassLeft Source["Filter Agency Records"]Left Key["ShippingCountry"]RelationshipClimateRight Source["Add Temp Class"]Right Key["Country"]Right Fields["TempClass","Country","Date","Temperature"]OperationLook Up Single ValueThanks in advance for your help, HI while trying to complete Determine Optimal Climates challenge Any Idea why am getting this Error "There was an unhandled exception. This part is the JSON from the original Load Seed Bank challenge which executed without error. i'm not able to understand what exactly is wrong with my approach.My approach:1. uploaded Seed Chart.txt from resource to create a dataset in mosiac app.2. Which of the Lenses are you working to create? What You'll be Doing to Earn This Superbadge Configure outbound application and integration security Configure inbound integration security Synchronize Salesforce data with external systems Synchronize external system data with Salesforce Test Apex REST and SOAP callout and service logic If you are familiar with report and dashboards, this challenge should only take 30 or so minutes to complete. To review, open the file in an editor that reveals hidden Unicode characters. Are this numbers correct?Thanks, Antonio. January 25, 2022 Data Integration Specialist Superbadge || Solutions || Easy Steps||All Challenges (1-10) Data Integration Specialist Challenge 1- (Quiz:Credential Security) :- Ans:-All of the above. Hi All, Need help for the below: I am trying to complete "Einstein Analytics Data Preparation Specialist" superbadge Challenge 4, I followed all the steps and cross checked multiple times still getting below error: Challenge Not yet complete here's what's wrong:We can't find the 'Load Seed Chart' node in the dataflow. Are you sure you want to create this branch? Alias - is incorrect. So much banging and so silly of me, i had the issues fixed, i passed the step 4, Even though i have done everything as mentioned, while creating the lens i am not able to see the acreage field under Bar length.