Skip to main content

partnerships

Creates, updates, deletes, gets or lists a partnerships resource.

Overview

Namepartnerships
TypeResource
Idaws.b2bi.partnerships

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
namestringReturns the display name of the partnership
capabilitiesarrayReturns one or more capabilities associated with this partnership.
capability_optionsobjectContains the details for an Outbound EDI capability.
created_atstring (date-time)Returns a timestamp for creation date and time of the partnership.
emailstringReturns the email address associated with this trading partner. (pattern: <code>[\w.-]+@[\w.-]+</code>)
modified_atstring (date-time)Returns a timestamp that identifies the most recent date and time that the partnership was modified.
partnership_arnstringReturns an Amazon Resource Name (ARN) for a specific Amazon Web Services resource, such as a capability, partnership, profile, or transformer.
partnership_idstringReturns the unique, system-generated identifier for a partnership. (pattern: <code>[a-zA-Z0-9_-]+</code>)
phonestringReturns the phone number associated with the partnership. (pattern: <code>+?([0-9 \t-()/]{7,})(?:\s*(?:#|x.?|ext.?|extension) \t*(\d+))?</code>)
profile_idstringReturns the unique, system-generated identifier for the profile connected to this partnership. (pattern: <code>[a-zA-Z0-9_-]+</code>)
trading_partner_idstringReturns the unique identifier for the partner for this partnership. (pattern: <code>[a-zA-Z0-9_-]+</code>)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_partnershipselectregionRetrieves the details for a partnership, based on the partner and profile IDs specified. A partnership represents the connection between you and your trading partner. It ties together a profile and one or more trading capabilities.
list_partnershipsselectregionLists the partnerships associated with your Amazon Web Services account for your current or specified region. A partnership represents the connection between you and your trading partner. It ties together a profile and one or more trading capabilities.
create_partnershipinsertregion, profileId, name, email, capabilitiesCreates a partnership between a customer and a trading partner, based on the supplied parameters. A partnership represents the connection between you and your trading partner. It ties together a profile and one or more trading capabilities.
update_partnershipupdateregion, partnershipIdUpdates some of the parameters for a partnership between a customer and trading partner. A partnership represents the connection between you and your trading partner. It ties together a profile and one or more trading capabilities.
delete_partnershipdeleteregionDeletes the specified partnership. A partnership represents the connection between you and your trading partner. It ties together a profile and one or more trading capabilities.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
regionstringAWS region (default: us-east-1)

SELECT examples

Retrieves the details for a partnership, based on the partner and profile IDs specified. A partnership represents the connection between you and your trading partner. It ties together a profile and one or more trading capabilities.

SELECT
name,
capabilities,
capability_options,
created_at,
email,
modified_at,
partnership_arn,
partnership_id,
phone,
profile_id,
trading_partner_id
FROM aws.b2bi.partnerships
WHERE region = '{{ region }}' -- required
;

INSERT examples

Creates a partnership between a customer and a trading partner, based on the supplied parameters. A partnership represents the connection between you and your trading partner. It ties together a profile and one or more trading capabilities.

INSERT INTO aws.b2bi.partnerships (
profileId,
name,
email,
phone,
capabilities,
capabilityOptions,
clientToken,
tags,
region
)
SELECT
'{{ profileId }}' /* required */,
'{{ name }}' /* required */,
'{{ email }}' /* required */,
'{{ phone }}',
'{{ capabilities }}' /* required */,
'{{ capabilityOptions }}',
'{{ clientToken }}',
'{{ tags }}',
'{{ region }}'
RETURNING
name,
capabilities,
capability_options,
created_at,
email,
partnership_arn,
partnership_id,
phone,
profile_id,
trading_partner_id
;

UPDATE examples

Updates some of the parameters for a partnership between a customer and trading partner. A partnership represents the connection between you and your trading partner. It ties together a profile and one or more trading capabilities.

UPDATE aws.b2bi.partnerships
SET
partnershipId = '{{ partnershipId }}',
name = '{{ name }}',
capabilities = '{{ capabilities }}',
capabilityOptions = '{{ capabilityOptions }}'
WHERE
region = '{{ region }}' --required
AND partnershipId = '{{ partnershipId }}' --required
RETURNING
name,
capabilities,
capability_options,
created_at,
email,
modified_at,
partnership_arn,
partnership_id,
phone,
profile_id,
trading_partner_id;

DELETE examples

Deletes the specified partnership. A partnership represents the connection between you and your trading partner. It ties together a profile and one or more trading capabilities.

DELETE FROM aws.b2bi.partnerships
WHERE region = '{{ region }}' --required
;