共用方式為


Pitney Bowes Tax Calculator [DEPRECATED]

Pitney Bowes Tax Calculator allows anyone to determine local tax jurisdictions & tax rates in the United States based on address inputs or location coordinates

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure Government regions
     -   Azure China regions
     -   US Department of Defense (DoD)
Power Automate Premium All Power Automate regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Power Apps Premium All Power Apps regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Contact
Name LBSSupport@pb.com
Connector Metadata
Publisher Not Available
Online Documentation https://docs.microsoft.com/connectors/geotax

It is critical for any billing, commerce, payment, or payroll application or service. To learn more, visit the documentation page: http://locate.pitneybowes.com/geotax

To use this integration, you need to have an account on the Pitney Bowes Developer Hub. Follow steps below to get your API Key and Secret.

If you see an error while using the connector you may look up the error code for more information.

Get the API Key and Secret

  • Register for a Pitney Bowes Developer Account.
  • Sign In with your Developer Account and select API Keys in the Locate menu.

You will see your API key and Secret listed on API Key page.

You're now ready to start using this integration.

Deprecation Information

The Pitney Bowes Tax Calculator connector has been deprecated as of August 2020 at the request of the connector publisher.

Creating a connection

The connector supports the following authentication types:

Default Parameters for creating connection. All regions Not shareable

Default

Applicable: All regions

Parameters for creating connection.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Name Type Description Required
API Key securestring The API Key for this api True
Secret securestring Your client secret for Pitney Bowes True

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Actions

Get IPD Tax by Address [DEPRECATED]

This will accept 'address' as a parameter and will return one or many IPDs details for that region in which address will fall.

Get IPD Tax for batch requests [DEPRECATED]

Get IPD Tax for batch requests

Get Tax By Address [DEPRECATED]

This service calculates and returns taxes applicable at a specific address. Address, purchase amount and supported tax rate type are inputs to the service.

Get Tax By Location [DEPRECATED]

This service calculates and returns tax applicable at a specific location. Longitude, latitude, purchase amount and supported tax rate type are inputs to the service.

Get Taxrate By Address [DEPRECATED]

Retrieves tax rates applicable to a specific address. This service accepts address and supported tax rate type as inputs to retrieve applicable tax rates.

Get Taxrate By Location [DEPRECATED]

Retrieves tax rates applicable to a specific location. This service accepts longitude, latitude and supported tax rate type as inputs to retrieve applicable tax rates.

Post Tax By Address [DEPRECATED]

This is a Batch offering for 'Tax By Address' service. It accepts a single address, purchase amount or a list of addresses, purchase amounts and retrieve applicable taxes.

Post Tax By Location [DEPRECATED]

This is a Batch offering for 'Tax By Location' service. It accepts a single location coordinate, purchase amount or a list of location coordinates, purchase amounts and retrieve applicable tax.

Post Taxrate By Address [DEPRECATED]

This is a Batch offering for 'Taxrate By Address' service. It accepts a single address or a list of addresses and retrieve applicable tax rates.

Post Taxrate By Location [DEPRECATED]

This is a Batch offering for 'Taxrate By Location' service. It accepts a single location coordinate or a list of location coordinates and retrieve applicable tax rates.

Get IPD Tax by Address [DEPRECATED]

This will accept 'address' as a parameter and will return one or many IPDs details for that region in which address will fall.

Parameters

Name Key Required Type Description
Address
address True string

The address to be searched.

Return Lat/Lon
returnLatLongFields string

This preference Option sets flag for returning geometry coordinates(Y/N)

Lat/Lon Format
latLongFormat string

(default is Decimal) - Returns Desired Latitude Longitude Format

Returns

Get IPD Tax for batch requests [DEPRECATED]

Get IPD Tax for batch requests

Parameters

Name Key Required Type Description
Unique ID
objectId string
Main Address Line
mainAddressLine string
Address Last Line
addressLastLine string
Place Name
placeName string
State or Province
areaName1 string
Area Name 2
areaName2 string
City or Town
areaName3 string
Area Name 4
areaName4 string
Postal Code
postCode1 string
Postal Code Ext
postCode2 string
Three-digit ISO country code
country string
Address Number
addressNumber string
Street Name
streetName string
Unit Type
unitType string
Unit Value
unitValue string
Fall Back to Geographic
fallbackToGeographic string
Match mode
matchMode string
Distance Unit
distanceUnits string
FIND_ADDR_POINT_INTERP
FIND_ADDR_POINT_INTERP string
FIND_SEARCH_AREA
FIND_SEARCH_AREA string
FIND_ADDRESS_RANGE
FIND_ADDRESS_RANGE string
FIND_EXPANDED_SEARCH_RADIUS
FIND_EXPANDED_SEARCH_RADIUS string
FIND_ALTERNATE_LOOKUP
FIND_ALTERNATE_LOOKUP string
FIND_STREET_CENTROID
FIND_STREET_CENTROID string
FIND_FIRST_LETTER_EXPANDED
FIND_FIRST_LETTER_EXPANDED string
Output Casting
outputCasing string
Lat/Lon offset
latLongOffset string
Squeeze Street End Points
squeeze string
Return Geometry coordinates(Y/N)
returnLatLongFields string
Return Census Fields(Y/N)
returnCensusFields string
Use GeoTAX Auxiliary File(Y/N)
useGeoTaxAuxiliaryFile string
Lat/Lon Return Format
latLongFormat string
Width ofPolygon Buffers
defaultBufferWidth string

Returns

Get Tax By Address [DEPRECATED]

This service calculates and returns taxes applicable at a specific address. Address, purchase amount and supported tax rate type are inputs to the service.

Parameters

Name Key Required Type Description
Tax Type
taxRateTypeId True string

The tax rate id.

Address
address True string

The address to be searched.

Purchase Amount
purchaseAmount True string

The amount on which tax to be calculated.

Returns

Get Tax By Location [DEPRECATED]

This service calculates and returns tax applicable at a specific location. Longitude, latitude, purchase amount and supported tax rate type are inputs to the service.

Parameters

Name Key Required Type Description
Tax Type
taxRateTypeId True string

The tax rate id.

Latitude
latitude True string

Latitude of the location.

Longitude
longitude True string

Longitude of the location.

Purchase Amount
purchaseAmount True string

The amount on which tax to be calculated.

Returns

Get Taxrate By Address [DEPRECATED]

Retrieves tax rates applicable to a specific address. This service accepts address and supported tax rate type as inputs to retrieve applicable tax rates.

Parameters

Name Key Required Type Description
Tax Type
taxRateTypeId True string

The tax rate id.

Address
address True string

The address to be searched.

Returns

Get Taxrate By Location [DEPRECATED]

Retrieves tax rates applicable to a specific location. This service accepts longitude, latitude and supported tax rate type as inputs to retrieve applicable tax rates.

Parameters

Name Key Required Type Description
Tax Type
taxRateTypeId True string

The tax rate id.

Latitude
latitude True string

Latitude of the location.

Longitude
longitude True string

Longitude of the location.

Returns

Post Tax By Address [DEPRECATED]

This is a Batch offering for 'Tax By Address' service. It accepts a single address, purchase amount or a list of addresses, purchase amounts and retrieve applicable taxes.

Parameters

Name Key Required Type Description
Tax Type
taxRateTypeId True string

The tax rate id.

Purchase Amount
purchaseAmount string
Unique ID
objectId string
Main Address
mainAddressLine string
Address Last Line
addressLastLine string
Place Name
placeName string
State or Province
areaName1 string
Area Name 2
areaName2 string
City or Town
areaName3 string
Area Name 4
areaName4 string
Postal Code
postCode1 string
Postal Code Ext
postCode2 string
Three-digit ISO country code
country string
Address Number
addressNumber string
Street Name
streetName string
Unit Type
unitType string
Unit Value
unitValue string
Distance Unit
distanceUnits string
Buffer Width
bufferWidth string
User Buffer Width
userBufferWidth string
Fall Back to Geographic
fallbackToGeographic string
Match mode
matchMode string
Distance Unit
distanceUnits string
FIND_ADDR_POINT_INTERP
FIND_ADDR_POINT_INTERP string
FIND_SEARCH_AREA
FIND_SEARCH_AREA string
FIND_ADDRESS_RANGE
FIND_ADDRESS_RANGE string
FIND_EXPANDED_SEARCH_RADIUS
FIND_EXPANDED_SEARCH_RADIUS string
FIND_ALTERNATE_LOOKUP
FIND_ALTERNATE_LOOKUP string
FIND_STREET_CENTROID
FIND_STREET_CENTROID string
FIND_FIRST_LETTER_EXPANDED
FIND_FIRST_LETTER_EXPANDED string
Output Casting
outputCasing string
Lat/Lon offset
latLongOffset string
Squeeze Street End Points
squeeze string
Return Geometry coordinates(Y/N)
returnLatLongFields string
Return Census Fields(Y/N)
returnCensusFields string
Use GeoTAX Auxiliary File(Y/N)
useGeoTaxAuxiliaryFile string
Lat/Lon Return Format
latLongFormat string
Width ofPolygon Buffers
defaultBufferWidth string

Returns

Post Tax By Location [DEPRECATED]

This is a Batch offering for 'Tax By Location' service. It accepts a single location coordinate, purchase amount or a list of location coordinates, purchase amounts and retrieve applicable tax.

Parameters

Name Key Required Type Description
Tax Type
taxRateTypeId True string

The tax rate id.

Purchase Amount
purchaseAmount string
Unique ID
objectId string
Geometry Type
type string
Coordinates(lat, lon)
coordinates array of double
Fall Back to Geographic
fallbackToGeographic string
Match mode
matchMode string
Distance Unit
distanceUnits string
FIND_ADDR_POINT_INTERP
FIND_ADDR_POINT_INTERP string
FIND_SEARCH_AREA
FIND_SEARCH_AREA string
FIND_ADDRESS_RANGE
FIND_ADDRESS_RANGE string
FIND_EXPANDED_SEARCH_RADIUS
FIND_EXPANDED_SEARCH_RADIUS string
FIND_ALTERNATE_LOOKUP
FIND_ALTERNATE_LOOKUP string
FIND_STREET_CENTROID
FIND_STREET_CENTROID string
FIND_FIRST_LETTER_EXPANDED
FIND_FIRST_LETTER_EXPANDED string
Output Casting
outputCasing string
Lat/Lon offset
latLongOffset string
Squeeze Street End Points
squeeze string
Return Geometry coordinates(Y/N)
returnLatLongFields string
Return Census Fields(Y/N)
returnCensusFields string
Use GeoTAX Auxiliary File(Y/N)
useGeoTaxAuxiliaryFile string
Lat/Lon Return Format
latLongFormat string
Width ofPolygon Buffers
defaultBufferWidth string

Returns

Post Taxrate By Address [DEPRECATED]

This is a Batch offering for 'Taxrate By Address' service. It accepts a single address or a list of addresses and retrieve applicable tax rates.

Parameters

Name Key Required Type Description
Tax Type
taxRateTypeId True string

The tax rate id.

Unique ID
objectId string
Main Address Line
mainAddressLine string
Address Last Line
addressLastLine string
Place Name
placeName string
State or Province
areaName1 string
Area Name 2
areaName2 string
City or Town
areaName3 string
Area Name 4
areaName4 string
Postal Code
postCode1 string
Postal Code Ext
postCode2 string
Three-digit ISO country code
country string
Address Number
addressNumber string
Street Name
streetName string
Unit Type
unitType string
Unit Value
unitValue string
Distance Unit
distanceUnits string
Buffer Width
bufferWidth string
User Buffer Width
userBufferWidth string
Fall Back to Geographic
fallbackToGeographic string
Match mode
matchMode string
Distance Unit
distanceUnits string
FIND_ADDR_POINT_INTERP
FIND_ADDR_POINT_INTERP string
FIND_SEARCH_AREA
FIND_SEARCH_AREA string
FIND_ADDRESS_RANGE
FIND_ADDRESS_RANGE string
FIND_EXPANDED_SEARCH_RADIUS
FIND_EXPANDED_SEARCH_RADIUS string
FIND_ALTERNATE_LOOKUP
FIND_ALTERNATE_LOOKUP string
FIND_STREET_CENTROID
FIND_STREET_CENTROID string
FIND_FIRST_LETTER_EXPANDED
FIND_FIRST_LETTER_EXPANDED string
Output Casting
outputCasing string
Lat/Lon offset
latLongOffset string
Squeeze Street End Points
squeeze string
Return Geometry coordinates(Y/N)
returnLatLongFields string
Return Census Fields(Y/N)
returnCensusFields string
Use GeoTAX Auxiliary File(Y/N)
useGeoTaxAuxiliaryFile string
Lat/Lon Return Format
latLongFormat string
Width ofPolygon Buffers
defaultBufferWidth string

Returns

Post Taxrate By Location [DEPRECATED]

This is a Batch offering for 'Taxrate By Location' service. It accepts a single location coordinate or a list of location coordinates and retrieve applicable tax rates.

Parameters

Name Key Required Type Description
Tax Type
taxRateTypeId True string

The tax rate id.

Purchase Amount
purchaseAmount string
Unique ID
objectId string
Geometry Type
type string
Coordinates(lat, lon)
coordinates array of double
Fall Back to Geographic
fallbackToGeographic string
Match mode
matchMode string
Distance Unit
distanceUnits string
FIND_ADDR_POINT_INTERP
FIND_ADDR_POINT_INTERP string
FIND_SEARCH_AREA
FIND_SEARCH_AREA string
FIND_ADDRESS_RANGE
FIND_ADDRESS_RANGE string
FIND_EXPANDED_SEARCH_RADIUS
FIND_EXPANDED_SEARCH_RADIUS string
FIND_ALTERNATE_LOOKUP
FIND_ALTERNATE_LOOKUP string
FIND_STREET_CENTROID
FIND_STREET_CENTROID string
FIND_FIRST_LETTER_EXPANDED
FIND_FIRST_LETTER_EXPANDED string
Output Casting
outputCasing string
Lat/Lon offset
latLongOffset string
Squeeze Street End Points
squeeze string
Return Geometry coordinates(Y/N)
returnLatLongFields string
Return Census Fields(Y/N)
returnCensusFields string
Use GeoTAX Auxiliary File(Y/N)
useGeoTaxAuxiliaryFile string
Lat/Lon Return Format
latLongFormat string
Width ofPolygon Buffers
defaultBufferWidth string

Returns

Definitions

address

Name Path Type Description
objectId
objectId string
displayName
displayName string
streetSide
streetSide string
businessName
businessName string
addressLine1
addressLine1 string
addressLine2
addressLine2 string
addressLine3
addressLine3 string
city
city string
stateProvince
stateProvince string
county
county string
postalCode
postalCode string
latitude
latitude string
longitude
longitude string
status
status string
urbanizationName
urbanizationName string
Matched Address formatted Address
formattedAddress string
Matched Address main addressLine
mainAddressLine string
Matched Address Last line
addressLastLine string
Matched Address place Name
placeName string
Matched Address State Name
areaName1 string
Matched Address county name
areaName2 string
Matched Address city Name
areaName3 string
Matched Address locality Name
areaName4 string
Matched Address Zip code
postCode string
Matched Address zip code extension
postCodeExt string
Matched Address country ISO code
country string
Matched Address address number
addressNumber string
Matched Address street Name
streetName string
Matched Address apartment/house type
unitType string
Matched Address apartment/house number
unitValue string

Geometry

Name Path Type Description
Geometry Type
type string
Coordinates(lat, lon)
coordinates array of double

SpecialPurposeDistrict

Name Path Type Description
SPD Name
districtName string
SPD district code
districtCode string
3-digit district type code
districtNumber string
SPD version date
versionDate string
SPD effective date
effectiveDate string
SPD compiled date
compiledDate string
SPD update date
updateDate string

UseTax

Name Path Type Description
Total Use Tax Rate
totalTaxRate double
Total Use Tax Amount
totalTaxAmount double
State Use Tax Rate
stateTaxRate double
State Use Tax Amount
stateTaxAmount double
County Use Tax Rate
countyTaxRate double
County Use Tax Amount
countyTaxAmount double
Municipality Use Tax Rate
municipalTaxRate double
Municipality Use Tax Amount
municipalTaxAmount double
spdsTax
spdsTax array of SpecialPurposeDistrictTax
specialTaxRulesApplied
specialTaxRulesApplied boolean
specialTaxRulesDescriptor
specialTaxRulesDescriptor string

County

Name Path Type Description
County Code
code string
County Name
name string
fips
fips string

SalesTax

Name Path Type Description
Total Sales Tax rate
totalTaxRate double
Total Sales Tax Amount
totalTaxAmount double
State Sales Tax Rate
stateTaxRate double
State Sales Tax Amount
stateTaxAmount double
County Sales Tax Rate
countyTaxRate double
County Sales Tax Amount
countyTaxAmount double
Municipality Sales Tax Rate
municipalTaxRate double
Municipality Sales Tax Aount
municipalTaxAmount double
spdsTax
spdsTax array of SpecialPurposeDistrictTax
Special Tax Rules Applied
specialTaxRulesApplied boolean
Special Tax Rules Descriptor
specialTaxRulesDescriptor string

Cbsa

Name Path Type Description
name
name string
code
code string

taxResponse

Name Path Type Description
objectId
objectId string
gnisCode
gnisCode string
Probability that the point falls in the specified Place
confidence double
jurisdiction
jurisdiction TaxJurisdiction
matchedAddress
matchedAddress address
salesTax
salesTax SalesTax
useTax
useTax UseTax
census
census Census
latLongFields
latLongFields LatLongFields

taxResponses

Name Path Type Description
taxResponses
taxResponses array of taxResponse

SpecialPurposeDistrictTax

Name Path Type Description
District Number of SPD
districtNumber string
Tax rate for SPD
taxRate double
Tax Amount for SPD
taxAmount double

TaxJurisdiction

Name Path Type Description
state
state State
county
county County
place
place Place
spds
spds array of SpecialPurposeDistrict

LatLongFields

Name Path Type Description
matchCode
matchCode string
matchLevel
matchLevel string
streetMatchCode
streetMatchCode string
streetMatchLevel
streetMatchLevel string
geometry
geometry Geometry

Mcd

Name Path Type Description
name
name string
code
code string

Census

Name Path Type Description
cbsa
cbsa Cbsa
matchLevel
matchLevel string
matchCode
matchCode string
tract
tract string
mcd
mcd Mcd

State

Name Path Type Description
fips
fips string
State Code
code string
State Name
name string

Place

Name Path Type Description
Place Name
name string
Place Code
code string
Place Class Code
classCode string
Place Incorporated Flag
incorporatedFlag string
Place Last Annexed Date
lastAnnexedDate string
Place Last updated Date
lastUpdatedDate string
Place Last Verified Date
lastVerifiedDate string

TaxDistrictResponseList

Name Path Type Description
taxDistrictResponse
taxDistrictResponse array of TaxDistrictResponse

TaxDistrictResponse

Name Path Type Description
Unique ID
objectId string
Percentage Overlap of Geocode
confidence double
jurisdiction
jurisdiction IPDTaxJurisdiction
Number of Insurance Premium Tax Districts
numOfIpdsFound integer
ipds
ipds array of ipd
matchedAddress
matchedAddress address
census
census Census
latLongFields
latLongFields LatLongFields

IPDTaxJurisdiction

Name Path Type Description
state
state State
county
county County
place
place Place

ipd

Name Path Type Description
IPD ID
id string
IPD Name
districtName string
districtType
districtType DistrictType
Tax code descriptions
taxCodeDescription string
IPD Effective Date
effectiveDate string
IPD Expiration Date
expirationDate string
boundaryBuffer
boundaryBuffer BoundaryBuffer
rates
rates array of rate

DistrictType

Name Path Type Description
Insurance Premium Districts Type
description string
value
value string

BoundaryBuffer

Name Path Type Description
bufferRelation
bufferRelation BufferRelation
distanceToBorder
distanceToBorder DistanceToBorder

rate

Name Path Type Description
Tax Rate Name
name string
Tax Rate Format
format string
Tax Rate Format Description
formatDescription string
value
value string

BufferRelation

Name Path Type Description
Buffer Relation Description
description string
Buffer Relation Value
value string

DistanceToBorder

Name Path Type Description
Ditance to Border Unit
unit string
Distance to Border Value
value string