data integration specialist superbadge challenge 5

Apex specialist superbadge challenge 4. I don't understand what you mean. It's been a while. so I hope this is good advice! { "Calculate Acreage": { "action": "computeExpression", "parameters": { "source": "Load Seed Chart", "mergeWithSource": true, "computedFields": [ { "name": "Acreage", "saqlExpression": "(Seeds_Pound*Spacing)/6272640", "label": "Acreage", "type": "Numeric", "precision": 18, "scale": 6 } ] } }, "Create Seed Bank": { "action": "sfdcRegister", "parameters": { "name": "Seed_Bank", "alias": "Seed Bank", "source": "Calculate Acreage" } }, "Load Seed Chart": { "action": "edgemart", "parameters": { "alias": "Seed_Chart" } }}do i need to delete the flat file and need to upload with seed_bank as the api name? not sure what is wrong here as i followed the same approach for challenge-3. Hey,Hope by this time you have got your answer if not,Please change the alias you will get through challenge 6. I've recreated the steps a number of times, and I am pretty sure all of my nomenclature is correct. 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! Are you sure you want to create this branch? A tag already exists with the provided branch name. still i'm facing the same issue. I am stuck at Challenge 6,7 . This special superbadge is designed to test how well you really grasped the underlying material and not just walk you through yet another predictable tutorial. Confirm the node name matches the name as described in the challenge. Lol, },"AddAgencyFields":{"action":"augment","parameters":{"right_key":["AccountNumber"],"left":"LoadAccount","left_key":["AccountNumber"],"right_select":["Acres","Currency","Latitude","Longitude","Region","SubRegion"],--- Can't match on field that is not in both data sets. Something that helped was saving the report frequently. 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! Appreciated! Fill Remote Site Name -->BillingService. Hi ,i am getting " The dataflow was completed, but the LookupSingleValue node didn't augment any columns. Can you elaborate? Right now he' taking a nap.so I'm off to edit some reports! My bad. Confirm there's a binding that filters attrition costs displayed in the reference line.Appreciate if you provide any help. Search for an answer or ask a question of the zone or Customer Support. I couldn't get through challenge 3 because I changed them to dimensions, and then now I had to change them back! I found that my saql expressions needed to have spaces:string_to_number(substr(Temperature, 1, 2))Now I am encountering another warning and I did try the suggestions, but I still cannot clear this message when I run the dataflow:The dataflow was completed, but the LookupSingleValue node didn't augment any columns. 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. Challenge 4: Test automation logic. This would take away from the purpose of the superbadge. let me know what i am missing here. )https://developer.salesforce.com/forums/?id=9060G0000005d3yQAA ---> This thread was very heplful! I am also stuck in Challenge4. If someone could guide me in the right direction, I'd really appreciate it. error in challenge 6. "{ "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" } }, i am posting remaining half in another comment due to html limit error. thanks.~. I've checked my spelling, order of parameters in the method signature. The error is in this - A name/alias is not correct:"Create Seed Bank": {"action": "sfdcRegister","parameters": {"name": "Create Seed Bank","alias": "Create_Seed_Bank","source": "Calculate Acreage". 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. To review, open the file in an editor that reveals hidden Unicode characters. Superbadge Apex Specialist looks good on Resume, and they prove worth it as well. Salesforce: Trailhead : Data Integration Specialist Challenge 5Helpful? Hi there.I made the changes as you suggested and still receiving the same error. OMG - I finally passed step #6.I totally redid the Load Seed Bank w/Climate and Load Seed Bank w/Temperature after I had to break down and have a Coke Zero after 3 yearslol.I also reloaded the datasets, etc.I have the final JSON if you want itThanks again. Configure a named credential and remote site according to the specifications outlined in the business requirements. My brother has started to play with me! wrong data? I'll look again through it Are your Latitude and Longitude uploads dimensions or measures? Any insight you may be able to provide would be great. If you could just post the JSON for your data flow, I will take a look. It looks like the order of operations is a tiny bit out of order. The sketch allowed me to organize all of the instructions into a reasonable order before I started clicking. I think I have the correct dataflow "Load Seed Bank Agencies w/Climate Data" What could it be? Below are tips and gotchas for each report / dashboard. Just in case my JSON{ "Load Seed Chart": { "action": "edgemart", "parameters": { "alias": "Seed_Chart" } }, "Calculate Acreage": { "action": "computeExpression", "parameters": { "mergeWithSource": true, "source": "Load Seed Chart", "computedFields": [ { "type": "Numeric", "name": "Acreage", "label": "Acreage", "saqlExpression": "(Seeds_Pound*Spacing)/6272640", "precision": 18, "scale": 6 } ] } }, "Create Seed Bank": { "action": "sfdcRegister", "parameters": { "source": "Calculate Acreage", "alias": "Seed Bank", "name": "Seed_Bank" } }}. This may even include some fields on objects being referenced in your code not being assigned to the user profile for the user in context. hmmm I'm happy to take a look at the json if you like. BTW thanks. },"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"This is not correct. Disclaimer: All information is provided \"AS IS\" without warranty of any kind. JSON:{ "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": "Calculate Acreage" } }, "Load Seed Chart": { "action": "edgemart", "parameters": { "alias": "Seed_Chart" } }}, Techforce services is a Salesforce Consulting Services in Australia Specializing in delivering end to end Salesforce solutions ,Consulting, Implementation DevOps partners in Australia We deliver applications and services more rapidly and reliably, but its more than a methodology it cuts to the very core. Trailhead Baby,I'm having an issue with Load Seed Bank w/Temperature ClassificationI keep getting this error after running the data flow and there is no data in the lens. @Trailhead Baby Can you post your JSON for the same? Either the node didn't find any matches, or a join key contains only null values.I believe it is because of this warning I cannot complete Step #6 because I am getting the following:Challenge 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. Various trademarks held by their respective owners. I have invested a lot of time solving the step 6 but seems no luck from last 2 weeks.Challenge Not yet complete here's what's wrong:We can't validate the 'Create Seed Bank Agencies' node was created correctly. 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. Can you please let me know what was the root cause? Check the challenge and confirm required field setting. The free lemonade offer worked! Which of the Lenses are you working to create? Here is my MaintenanceRequestHelper class. (full disclosure-- I did this superbadge twice because I didn't fully understand the first timeso don't feel bad about being lost! https://developer.salesforce.com/forums/?id=9060G0000005d3yQAA, Business Administration Specialist Superbadge- 3 & 4, Lightning Experience Reports & Dashboards Specialist Superbadge - 5-6, Process Automation Specialist Superbadge - 5. Check the challenge and confirm the node name and required fields. created a dataflow with name "Load Seed Bank" . It also removed the approval steps from Process Builder and highlighted (with *'s) the prerequisite items to building my process. Check the challenge and confirm the node name and required fields{ "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" } ] } }, "Load Seed Chart": { "action": "edgemart", "parameters": { "alias": "Seed_Chart" } }, "Load Temp Class Mapping": { "action": "edgemart", "parameters": { "alias": "Temperature_Classes_Mapping" } }, "Define Temp Range": { "action": "computeExpression", "parameters": { "mergeWithSource": true, "source": "Calculate Acreage", "computedFields": [ { "type": "Numeric", "name": "LowTemp", "label": "LowTemp", "saqlExpression": "string_to_number(substr(Temperature, 1, 2))", "precision": 18, "scale": 2 }, { "type": "Numeric", "name": "HighTemp", "label": "HighTemp", "saqlExpression": "string_to_number(substr(Temperature, -2, 2))", "precision": 18, "scale": 2 } ] } }, contd"Add Temp Class": { "action": "computeExpression", "parameters": { "mergeWithSource": true, "source": "Define Temp Range", "computedFields": [ { "type": "Text", "name": "TempClass", "label": "TempClass", "saqlExpression": "case when Temperature < \"25\" then \"Polar\" \nwhen Temperature >= \"25\" and Temperature <= \"50\" then \"Cool\" when Temperature >= \"51\" and Temperature <= \"85\" then \"Continental\" \nwhen Temperature > \"85\" then \"Tropical\" \nend", "precision": 18 } ] } }, "Augment Temp Class": { "action": "augment", "parameters": { "operation": "LookupSingleValue", "left": "Add Temp Class", "relationship": "Climate", "right": "Load Temp Class Mapping", "left_key": [ "TempClass" ], "right_key": [ "TempKey" ], "right_select": [ "TempClass" ] } }, "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" } }}. If you post your revised JSON, I'll take a look. Check the challenge and confirm required field setting." i changed "name" to "seed bank". Getting below error. yipeeeee ! I am stuck on creating the test class for the challenge 4 in a propper way. 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. Hi Trailhead Baby,Please help me. Modified 2 months ago. Hi,i'm facing an issue in Challenge-4. Still getting the same message.Thanks!Karen. When validating the challenge, i'm getting an error stating this:-"Challenge Not yet complete here's what's wrong:We can't find the Seed Bank dataset or required fields are missing. I enjoy playing on Trailhead, taking long walks with mommy, watching the Florida Gators with daddy, and chasing my two dogs. I solved this by putting the opportunity record and project record into separate list and performing DML on the list. thank you for the light, tried the below ways nothing worked "Create Seed Bank": { "action": "sfdcRegister", "parameters": { "name": "Seed Bank", "alias": "Seed_Bank", "source": "Calculate Acreage" } }, "Create Seed Bank": { "action": "sfdcRegister", "parameters": { "name": "seed bank", "alias": "seed_bank", "source": "Calculate Acreage" } }. Hint - The TempClass formula is different for each of the dataflows. thanks a lot. Thanks! such a silly mistake it was and i was stuck there for long. I didn't look through the whole JSON yet, but that's my bet. Please find JSON below:{ "Load Seed Chart": { "action": "edgemart", "parameters": { "alias": "Seed_Chart" } }, "Calculate Acreage": { "action": "computeExpression", "parameters": { "mergeWithSource": true, "source": "Load Seed Chart", "computedFields": [ { "type": "Numeric", "saqlExpression": "(Seeds_Pound*Spacing)/6272640", "precision": 18, "scale": 6, "name": "Acreage", "label": "Acreage" } ] } }, "Create Seed Bank": { "action": "sfdcRegister", "parameters": { "source": "Calculate Acreage", "alias": "seed_bank", "name": "Create Seed Bank" } }}then ran this dataflow and created a lens with the dataset created. ok, I got through the other errors. I am getting this error from step 4 Challenge Not yet complete here's what's wrong:We can't find the 'Load Seed Chart' node in the dataflow. Are this numbers correct?Thanks, Antonio. 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, 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. @Maulik Vadodariya Just follow instruction .My issue been resolved .https://success.salesforce.com/answers?id=9063A000000lixEQAQ, I am so lost on step 6. 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? | Content (except music \u0026 images) licensed under CC BY-SA https://meta.stackexchange.com/help/licensing | Music: https://www.bensound.com/licensing | Images: https://stocksnap.io/license \u0026 others | With thanks to user TSmith (salesforce.stackexchange.com/users/30493), user John Mutuma (salesforce.stackexchange.com/users/68710), user Daniel Deepak (salesforce.stackexchange.com/users/73968), and the Stack Exchange Network (salesforce.stackexchange.com/questions/300749). ), Hi Steve - How did you fix the "We can't confirm these are the correct values in the lens. 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. Anyway, sorry for bothering. Thanks Ill have to put this in two post. The data flow is running properly. I just checked in my data sets i kind of uploaded twice for seed chart file, so i deleted the first version of it, kept the latest version under Mosiac app, named it as " Seed Chart" and api name is "Seed_Chart"here is new error ""and my jason is ::We can't find the Seed Bank dataset or required fields are missing. Tried this }, "Augment TempClass": { "action": "augment", "parameters": { "right_key": [ "Country" ], "left": "Load Seed Bank Agencies", "left_key": [ "ShippingCountry" ], "right_select": [ "TempClass" ], "right": "Add Temp Class", "relationship": "Climate", "operation": "LookupSingleValue"But Still throwing the same error. 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. Thanks much :), Hi I am getting the bellow error. Hi,Can you please let me know the correct values of both lens. If you are short on time, start around the 20 minute mark. To complete the challenges, you need to pre-populate the Account object with data associated with this superbadge. Check the required fields, field types, node name, and alias are correct. Note the filter. The Trigger doesn't seem to be saving either on the Developer Console or the Apex Trigger in Setup. Thanks for your help. The dataflow was completed, but the LookupSingleValue node didn't augment any columns. Apex Specialist SuperBadge 5. Processes. First I create a min and max temp, then how do I use two fields to get a temperature category? What a sun of gun i had to change the dataset association and now works!! Its giving me a syntax error. Reports Accounts by Market To create the "Market" row grouping, use a bucket field. He laughs when I poke his nose and tries to take toys out of my hand. If you would like to start with something a little easier, I'd go for the Security Specialist. R&D, A project with Daddy: My favorite daily process! Confirm the node name matches the name as described in the challenge. oops i got it solved. When I made mistakes, I simply reverted to the last saved version. Copyright 2000-2022 Salesforce, Inc. All rights reserved. Slack to Salesforce Integration using Apex Trigger, Test Class Not Covered. Learn more about bidirectional Unicode characters. JSON for filter node:"Filter 2015": { "action": "computeExpression", "parameters": { "source": "Load Climate", "mergeWithSource": true, "computedFields": [ { "saqlExpression": "Date_Year:EQ:2015", "name": "Date_Year", "label": "Date_Year", "type": "Text" } ] } },Thanks, I have the action as "filter", not "computeExpression". "name": "Create Seed Bank" - This is incorrect. Could you please let me know the issue in challenge 4:{ "Load Seed Chart": { "action": "edgemart", "parameters": { "alias": "Load_Seed_Chart" } }, "Calculate Acreage": { "action": "computeExpression", "parameters": { "mergeWithSource": true, "source": "Load Seed Chart", "computedFields": [ { "type": "Numeric", "name": "Acreage", "label": "Acreage", "saqlExpression": "(Seeds_Pound*Spacing)/6272640", "precision": 18, "scale": 6 } ] } }, "Create Seed Bank": { "action": "sfdcRegister", "parameters": { "alias": "seed_bank", "source": "Calculate Acreage", "name": "Create Seed Bank" }, "Load Seed Chart": {"action": "edgemart","parameters": {"alias": "Load_Seed_Chart"Wrong Alias, Hello.Thank you for all of your assistance so far and the link you provided is extremely helpful!I am banging my head against the wall on the following error when I am trying to run the dataflow for Load Seed Bank w/Temperature Classification:Something went wrong while executing the Define Temp Range node: invalid field expression for field 'LowTemp': Syntax Error at position [line 1: column 45] after token , :: ;rature,1,2))",; (02K6g000000ZTAJEA4_03C6g000001DuzvEAC)Here is my saql expression for LowTemp:"string_to_number(substr(Temperature,1,2))",It is defined as Numeric and I have the precision: 18 and scale: 2, default value: 0The source is Calculate Average.I am hoping it is something obvious that I am overlooking :-)Thanks again!Karen. Can you please post your JSON for the dataflow or at least the Define Temp Range and Add Temp Class nodes? What I did wrong? https://docs.google.com/document/d/1RaNsOtQZlsL_yVTd0NWkox9kpyV1LLJ60fWBEVQwsLI/edit?usp=sharing. Thank you so much Rebeca, My step 6 is resolved finally today. 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 have completed my step 7 already but could not proceed because of step 6 issues. Data Integration Specialist : What You'll Be Doing to Earn This SuperbadgeConfigure outbound application and integration securityConfigure inbound integratio. Executive Report Tips: SolarBot Loyalty Revenue This report is tricky, but I don't want to give away the solution!