This section describes the requirements for creating external defined function named 'geotax' by using these examples.
Below important headers must be passed in external defined function:
- headers-api-key: It expects DIS API's production environment key.
- headers-api-secret: It expects DIS API's production environment secret.
Note: The user should replace '<<DIS API KEY>>' and '<<DIS
API SECRET>>' with own API Key and API Secret.
Sample UDF
This script is used for input addresses and expects JSON object as an input parameter.create or replace external function geotax_address(address object)
returns variant
IMMUTABLE
api_integration = API_INTEGRATION
REQUEST_TRANSLATOR = geotax_preference_request_translator
HEADERS = ('headers-api-key'= '<<API KEY>>', 'headers-api-secret'='<<API SECRET>>')
MAX_BATCH_ROWS = 10
as 'https://9a3cydoxrc.execute-api.us-east-1.amazonaws.com/v1/geo-tax-address';