Lookup

Gets data from a lookup table and adds it to frames.

Name	Default	Meaning
format		The format of the table (JSON or CSV)
prefix		A prefix to be added to lookup value names
sufffix		A suffix to be added to lookup value name
key		The name of the frame attribute used to in the lookup
rkey		The name of the lookup table column/property that matches the key
url		The URL to download the content from

This function searches url for any cases where rkey matches the value of key in our frame.

This is often used to load product details or other useful tabular data into a capture.

If the frame contains the following attributes…

and we have the following table…

SKU	Weight	Height	Width	Depth
AR97A	500	100	100	100
AR97B	800	120	120	120
AR44X	1200	1200	120	120

{
   "type": "lookup",
   "url": "https://mylookuptable",
   "key": "ProductSKU",
   "rkey" : "SKU",
   "prefix": "Product"
}

The final results attributes will look like…