Lookup Time Zone by Zip Code Data Flow Template



This Data Flow template is made up of two Data Operations that allow app builders to find time zone information based on a given US zip code. 

In Connections Builder, Data Flow templates can be found with pre-populated sample data. However, to meet the requirements of their Journey, app builders should perform the necessary adjustments, such as adding other Data Ops.

Lookup Time Zone by Zip Code Data Operations

This Data Flow contains four parts:


The Start pane keeps track of the inputs required by the Data Flow. 

  • Service: Rapid API
  • Method: GET - to retrieve data
  • URL: This Airscript expression requires an account with the Rapid API (For more information, see https://rapidapi.com/redline/api/redline-zipcode)
  • Allow non-compliant HTTP headers: box unchecked
  • Content-Type: “application/json”
  • Headers: no parameter set
  • Query Parameters: no parameter set
  • Form Parameters: no parameter set
  • Had paging?: box unchecked
  • Run Results: AirData Variables of type Any that automatically created to hold the results of this Operation. 
    + result
    + rawResult
    + request

  • Transform Expression: Airscript expression to identify the corresponding time zone.
  • Output Format: Variable
  • Type: Any
  • Run Results: transform output Variable of type Any that is automatically created to hold the result of this Operation.


The End step is where variables from the Data Flow can be used as an output..

  • Sample Return Value: transform of type Any

Use Cases

  • Allow app builders to provide a US zip code and receive its corresponding time zone.