Right now he' taking a nap.so I'm off to edit some reports! Check the challenge and confirm required field setting." Still stuck? I've checked my spelling, order of parameters in the method signature. Hi I am completely new this superbadges. { "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" } ] } }}. This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. Hi, I am getting the message: Something went wrong while executing the Augment Temp Class node: Duplicate field TempClassCan you help me with my JSON? Please reference ID: UAPSIKJH. Agency Temp Class lens? . I am getting this error from step 4Challenge Not yet complete here's what's wrong:We can't find the 'Load Seed Chart' node in the dataflow. The JSON looks right. You signed in with another tab or window. And correct me if i am wrong any where.Challenge Not yet complete here's what's wrong:We can't find the Seed Bank dataset or required fields are missing. Take a break, grab a snack, and watch this video. here's what's wrong: Please support me on Patreon: https://www.patreon.com/roelvandepaarWith thanks \u0026 praise to God, and with thanks to the many people who have made this project possible! Step-2:- Then go to Setup-->Remote Site Settings-->New Remote Site. This part is the JSON from the original Load Seed Bank challenge which executed without error. https://docs.google.com/document/d/1RaNsOtQZlsL_yVTd0NWkox9kpyV1LLJ60fWBEVQwsLI/edit?usp=sharing. 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 The trickiest part is the formulas for Definie Temp Range and Add TempClass. Define Temp Range- I needed help to figure this one out as well!string_to_number( substr(Temperature,1,2)) for Lowstring_to_number(substr(Temperature,-2,2)) for HighAdding the Temp Class: The SAQL starts with casewhen lowTemp < 25 and highTemp < 25 then "Polar" - then you define the rest of the ranges. Confirm the node name matches the name as described in the challenge. I actually deleted the dataflow and recreated it, too. Is anyone working on this Superbadge or did I just got too late?I'm trying to get to this one: "Determine Optimal ClimatesBuild a dataflow to add temperature classes to the Seed Bank Agencies and Seed Bank datasets. (It's a capitalization issue) },"Create Seed Bank": {"action": "sfdcRegister","parameters": {"name": "Seed Bank","alias": "Seed_Bank","source": "Calculate Acerage", Hi,I am stuck in step 6 Load Seed Bank Agencies w/Climate Data while running the data flow.Below is the ErrorSomething went wrong while executing the Augment TempClass node: Duplicate field TempClass (02K2x000000EEiPEAW_03C2x000000BNimEAG)Below is the 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" } ] } }, "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 Seed Bank Agencies": { "action": "edgemart", "parameters": { "alias": "seed_bank_agencies" } }, "Filter 2015": { "action": "filter", "parameters": { "filter": "Date_Year:R:2015", "source": "Load Climate" } }, "Augment TempClass": { "action": "augment", "parameters": { "left": "Load Seed Bank Agencies", "right": "Add Temp Class", "relationship": "Climate", "operation": "LookupSingleValue", "left_key": [ "ShippingCountry" ], "right_key": [ "Country" ], "right_select": [ "TempClass" ] } }}. It was the Long/Lat settings in the Agency Detail upload. },"CreateSeedBankAgencies":{"action":"sfdcRegister","parameters":{"name":"SeedBankAgencies","alias":"seed_bank_agencies","source":"AugmentTempClass"I have different spacing in the name.My original thought was with the "augument" step- because I have seen this throw errors a ton of times if "account number" was not explicitly selected in both data sets. Thanks a lot! Hi,Can you please let me know the correct values of both lens. Can you suggest which super badge i should start with? oops i got it solved. However, if I test my code from workbench, it works correctly. I enjoy playing on Trailhead, taking long walks with mommy, watching the Florida Gators with daddy, and chasing my two dogs. Step 6 is tricky! If someone could guide me in the right direction, I'd really appreciate it. Please check your work. Please check your work." 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. If you could kindly give me some insight as i fear i'm missing something here. },"CleanUp": {"action": "sliceDataset","parameters": {"mode": "drop","source": "Augment Temp Class","fields": [{"name": "TempClass"},{"name": "TempKey"},{"name": "Climate.lowtemp"},{"name": "Climate.hightemp"}this is incorrect. i changed "name" to "seed bank". Fill Remote Site Name -->BillingService. Check the challenge and confirm the node name and required fields.Below is my JSON details. Make sure that the correct date range is selected. Either the node didn't find any matches, or a join key contains only null values. Copyright 2000-2022 Salesforce, Inc. All rights reserved. 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. He laughs when I poke his nose and tries to take toys out of my hand. still i'm facing the same issue. Check the challenge and confirm the node name and required fields. I don't understand what you mean. I am stuck at Challenge 6,7 . Hi man, have you been able to solve this? },"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. not sure what is wrong here as i followed the same approach for challenge-3. Hello,Step 6 :When running my My Load Seed Bank Agencies w/Climate Dataflow in the Monitor, this warning message appears : The dataflow was completed, but the Augment TempClass node didn't augment any columns. A tag already exists with the provided branch name. Making dinner for Mom! 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, yipeeeee ! Have you guessed the theme of the photos that go along with the Trailhead - Process Automation Specialist Superbadge series?They are a few of my favorite day to day processes! 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. High Value Residential This report includes: 1 filter, 1 grouping, and 1 summarized field. There are a couple of YouTube channels that cover almost every Superbadge step . The best of luck! I have the same nodes as you, but I dont understand how you are supposed to multi join or the two nodes before that. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Copyright 2000-2022 Salesforce, Inc. All rights reserved. Check the required fields, field types, node name, and alias are correct. 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. This comment has been removed by the author. Salesforce Trailhead Superbadge 'Data Integration Specialist' Data Integration Specialist is one of the superbadges of Salesforce trailhead (A New Approach to Learning Salesforce). Onwards to Step #7.Karen, Could you please give me the final json? !I can't copy here all the code, so I have copy in Gdrive. 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 commit does not belong to any branch on this repository, and may belong to a fork outside of the repository. Check the required fields, field types, node name, and alias are correct. If you are familiar with report and dashboards, this challenge should only take 30 or so minutes to complete. Here is my JSON:{ "Add Temp Class": { "action": "computeExpression", "parameters": { "source": "Define Temp Range", "mergeWithSource": true, "computedFields": [ { "name": "TempClass", "saqlExpression": "case when LowTemp < 25 and HighTemp < 25 then \"Polar\"\nwhen LowTemp >= 25 and HighTemp <= 50 then \"Cool\"\nwhen LowTemp >= 51 and HighTemp <= 85 then \"Continental\"\nwhen LowTemp >= 85 then \"Tropical\" end", "label": "TempClass", "type": "Numeric" } ] } }, "Calculate Acreage": { "action": "computeExpression", "parameters": { "source": "Load Seed Chart", "mergeWithSource": true, "computedFields": [ { "precision": 18, "saqlExpression": "(Seeds_Pound*Spacing)/6272640 ", "name": "Acreage", "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": "Add Temp Class", "left_key": [ "TempClass" ], "right_select": [ "TempClass", "TempKey" ], "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" }, { "name": "Climate.TempClass" }, { "name": "Climate.TempKey" }, { "name": "TempClass" } ] } }, "Define Temp Range": { "action": "computeExpression", "parameters": { "source": "Calculate Acreage", "mergeWithSource": true, "computedFields": [ { "defaultValue": "0", "saqlExpression": "string_to_number(substr(Temperature, 1, 2))\n\n", "name": "LowTemp", "label": "LowTemp", "type": "Numeric" }, { "name": "HighTemp", "saqlExpression": "string_to_number(substr(Temperature, -2, 2))", "label": "HighTemp", "type": "Numeric" } ] } }}, I am so lost on step 6. When I made mistakes, I simply reverted to the last saved version. Confused? Can you elaborate? I have done ADMIN & PD1. The dataset is created by the dataflow that you create. (IE- I don't see it in your right select) I also have one additional character in this SAQL"saqlExpression":"casewhenPhoneisnotnullthen\"TRUE\"else\"FALSE\"end", Eureka! 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. Please support me on Patreon: https://www.patreon.com/roelvandepaarWith thanks & pra. but when checked the challenge i am getting this error mentioned belowChallenge Not yet complete here's what's wrong:We can't find the 'Create Seed Bank Agencies' node or required fields, such as 'TempClass', are missing. Node Augment TempClass refers to field TempClass not present in right source. created a dataflow with name "Load Seed Bank" . Beside changing the alias and name the thing i wasn't realizing is that the process was creating a dataset but in the SHARED APP! Key value should be the same. @Shruthi, did you got the issue fixed?