I know others have faced this issue before and have successfully resolved it. I've looked through this forum for sources of errors, but none of the suggestions seem to have worked for me. Please take a look and point out where I'm tripping up. Thanks!
What have I tried?
- The dataflow 'Load Seed Bank Agencies' runs successfully, i.e. with out any errors
- The dataflow is similar to solutions posted on this form
- Comapred the JSON file against others posted here, couldn't find material diff
- Top 5 Agencies lens and the dataset is saved in the Mosaic app
- Created a new dev org and run the Step 3 challenge a few times
- Been through the YouTube video pointed out by others in this forum
What are the output fields of node 'Create Seed Bank Agencies: sfdcRegister' (snapshot)?
What does the JSON file look like?
{
"Load Account": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "Name"
},
{
"name": "AccountNumber"
},
{
"name": "Phone"
},
{
"name": "ShippingCity"
},
{
"name": "ShippingCountry"
},
{
"name": "ShippingState"
},
{
"name": "ShippingStreet"
},
{
"name": "ShippingPostalCode"
}
],
"object": "Account"
}
},
"Load Agency Detail": {
"action": "edgemart",
"parameters": {
"alias": "Agency_Detail"
}
},
"Add Agency Fields": {
"action": "augment",
"parameters": {
"operation": "LookupSingleValue",
"left": "Load Account",
"left_key": [
"AccountNumber"
],
"relationship": "AgencyDetail",
"right": "Load Agency Detail",
"right_key": [
"AccountNumber"
],
"right_select": [
"Acres",
"Currency",
"Latitude",
"Longitude",
"SubRegion",
"Region"
]
}
},
"ID Agency Records": {
"action": "computeExpression",
"parameters": {
"mergeWithSource": true,
"source": "Add Agency Fields",
"computedFields": [
{
"type": "Text",
"name": "IsAgency",
"label": "IsAgency",
"saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end"
}
]
}
},
"Filter Agency Records": {
"action": "filter",
"parameters": {
"source": "ID Agency Records",
"filter": "IsAgency:EQ:TRUE"
}
},
"Create Seed Bank Agencies": {
"action": "sfdcRegister",
"parameters": {
"source": "Filter Agency Records",
"alias": "seed_bank_agencies",
"name": "Seed Bank Agencies"
}
}
}
Hi Ines,
Thanks for your response and the point about not sharing information about such challenges. I'll delete this question just to make sure I comply.
