C:\ProgramData\Alteryx\Engine\Engine_17024_331741706f1d499d87ff088337952cd9_\Engine_13344_775b1f51afdc48a79dcd5e71214cd297_.yxdb
Data
API Request
PasteYourURLHere
Paste Your URL Here
Live query API
String
65001
GET
Compose
1
1000
Parse Response
DownloadData
Rough JSON parsing
Trim the base JSON field prefix
JSON_Name=trim([JSON_Name],".0.text")
JSON_Name
Replace
JSON_Name
Warn
JSON_Name_Matched
Parse out wanted fields
Replace:
^\w*\.\w*\.\d{1,}\.\w*\.\d\...
$1
Custom
Remove extractor query data
Contains([JSON_Name],"pageData") or Contains([JSON_Name],"rac...
,
Reshape to tabulated format
UniqueValue
Tile by field (JSON_Name) unique value for crosstab
Unique Value
Move/shed fields
Horizontal
Webscrape