Snickers
45318373
Candy Corn
45214366
Tootsie Roll Pop
45157442
Sweetarts
45262886
Atomic Fireballs
45213587
Chewy Sours
45245489
Sour Patch Kids
45164706
NDB Lookup
Sour Patch Kids 3, Snickers 15, Atomic Fireballs 15, Candy Corn 30, Sweetarts 25
Bag
Bag
Bag
ParseComplex
Warn
Bag_Matched
Parse:
\s*(.+?)\s*(\d+)
Create URL
API Key = "oQrbVTRtANxsxp0RrA7OxZP3zL3ZDloogC3KMhwu"
URL = "https://api.nal.usda...
?
&
Candy
Candy
Candy
FindAny
Append
URL
String
65001
GET
Compose
2
600
DownloadData
Contains([JSON_Name],"ndbno")
OR
Contains([JSON_Name], "nutrients.0.value")
Custom
Contains
JSON_Name
True
fixed
2018-11-14 21:21:53
0
ndbno
2018-11-14 21:21:53
2018-11-14 21:21:53
select needed fields
Contains([JSON_Name],"ndbno")
OR
Contains([JSON_Name], "nutrients.0.value")
2
arrange into
columns
fix data
types
Horizontal
challenge_139_EHB_completed