• Pia-Han Kersting 5
  • NEWBIE
  • 5 Points
  • Member since 2018

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 1
    Likes Given
  • 1
    Questions
  • 3
    Replies

Hello everonyone, I stuck on challenge #6. I hope that anybody could help me.

"Challenge Not yet complete... here's what's wrong: 
We can't find the 'Create Seed Bank Agencies' node or required fields are missing. Check the challenge and confirm the node name and required fields."

This is my JSON:

{
  "Filter Agency Records": {
    "action": "filter",
    "parameters": {
      "filter": "IsAgency:EQ:TRUE",
      "source": "ID Agency Records"
    }
  },
  "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "Phone"
        },
        {
          "name": "ShippingCity"
        },
        {
          "name": "ShippingCountry"
        },
        {
          "name": "AccountNumber"
        },
        {
          "name": "Name"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingStreet"
        },
        {
          "name": "ShippingPostalCode"
        }
      ],
      "object": "Account"
    }
  },
  "Add TempClass": {
    "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 w/Climate Data",
      "alias": "seed_bank_agencies_with_climate_data",
      "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",
        "Temperature",
        "TempClass"
      ],
      "right": "Add TempClass",
      "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"
        }
      ]
    }
  }
}

Hello everonyone, I stuck on challenge #6. I hope that anybody could help me.

"Challenge Not yet complete... here's what's wrong: 
We can't find the 'Create Seed Bank Agencies' node or required fields are missing. Check the challenge and confirm the node name and required fields."

This is my JSON:

{
  "Filter Agency Records": {
    "action": "filter",
    "parameters": {
      "filter": "IsAgency:EQ:TRUE",
      "source": "ID Agency Records"
    }
  },
  "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "Phone"
        },
        {
          "name": "ShippingCity"
        },
        {
          "name": "ShippingCountry"
        },
        {
          "name": "AccountNumber"
        },
        {
          "name": "Name"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingStreet"
        },
        {
          "name": "ShippingPostalCode"
        }
      ],
      "object": "Account"
    }
  },
  "Add TempClass": {
    "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 w/Climate Data",
      "alias": "seed_bank_agencies_with_climate_data",
      "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",
        "Temperature",
        "TempClass"
      ],
      "right": "Add TempClass",
      "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"
        }
      ]
    }
  }
}

Hi,

I got following error on step 3.

Challenge Not yet complete... here's what's wrong: 
Couldn’t find Agency records from the Account object.

Can anyone pass this step?
Thanks in advance.

Regards,
LinThaw
Hi,

I got following error on step 3.

Challenge Not yet complete... here's what's wrong: 
Couldn’t find Agency records from the Account object.

Can anyone pass this step?
Thanks in advance.

Regards,
LinThaw