Intercom 엔터티에서 읽기

사전 조건

읽으려는 Intercom 객체. 사용 가능한 엔터티를 확인하려면 아래 지원되는 엔터티 테이블을 참조하세요.

지원되는 엔터티

개체	API_Version	필터링 가능	제한 지원	정렬 기준 지원	Select * 지원	분할 지원
Admins	v2.5	아니요	아니요	아니요	예	아니요
회사	v2.5	아니요	예	아니요	예	아니요
Conversations	v2.5	예	예	예	예	예
데이터 속성	v2.5	아니요	아니요	아니요	예	아니요
Contacts	v2.5	예	예	예	예	예
Segments	v2.5	아니요	아니요	아니요	예	아니요
Tags	v2.5	아니요	아니요	아니요	예	아니요
팀	v2.5	아니요	아니요	아니요	예	아니요

예제


Intercom_read = glueContext.create_dynamic_frame.from_options(
    connection_type="Intercom",
    connection_options={
        "connectionName": "connectionName",
        "ENTITY_NAME": "company",
        "API_VERSION": "V2.5"
    }
)

Intercom 엔터티 및 필드 세부 정보

개체	필드	데이터 형식	지원되는 연산자
Admins	type	String	NA
Admins	id	String	NA
Admins	avatar	Struct	NA
Admins	name	String	NA
Admins	이메일	String	NA
Admins	away_mode_enabled	불	NA
Admins	away_mode_reassign	불	NA
Admins	has_inbox_seat	불	NA
Admins	teams_ids	나열	NA
Admins	job_title	String	NA
회사	type	String	NA
회사	id	String	NA
회사	app_id	String	NA
회사	created_at	DateTime	NA
회사	remote_created_at	DateTime	NA
회사	updated_at	DateTime	NA
회사	last_request_at	DateTime	NA
회사	계획	Struct	NA
회사	company_id	String	NA
회사	name	String	NA
회사	custom_attributes	Struct	NA
회사	session_count	Integer	NA
회사	monthly_spend	Integer	NA
회사	user_count	Integer	NA
회사	industry	String	NA
회사	size	Integer	NA
회사	웹 사이트	String	NA
회사	tags	Struct	NA
회사	segments	Struct	NA
Contacts	id	String	EQUAL_TO.NOT_EQUAL_TO
Contacts	type	String	NA
Contacts	workspace_id	String	NA
Contacts	external_id	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Contacts	role	String	EQUAL_TO.NOT_EQUAL_TO
Contacts	이메일	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Contacts	phone	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Contacts	name	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Contacts	avatar	String	NA
Contacts	owner_id	Integer	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Contacts	social_profiles	Struct	NA
Contacts	has_hard_bounced	불	EQUAL_TO
Contacts	marked_email_as_spam	불	EQUAL_TO
Contacts	unsubscribed_from_emails	불	EQUAL_TO
Contacts	created_at	DateTime	EQUAL_TO, GREATER_THAN, LESS_THAN
Contacts	updated_at	DateTime	EQUAL_TO, GREATER_THAN, LESS_THAN
Contacts	signed_up_at	DateTime	EQUAL_TO, GREATER_THAN, LESS_THAN
Contacts	last_seen_at	DateTime	EQUAL_TO, GREATER_THAN, LESS_THAN
Contacts	last_replied_at	DateTime	EQUAL_TO, GREATER_THAN, LESS_THAN
Contacts	last_contacted_at	DateTime	EQUAL_TO, GREATER_THAN, LESS_THAN
Contacts	last_email_opened_at	DateTime	EQUAL_TO, GREATER_THAN, LESS_THAN
Contacts	last_email_clicked_at	DateTime	EQUAL_TO, GREATER_THAN, LESS_THAN
Contacts	language_override	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Contacts	브라우저	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Contacts	browser_version	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Contacts	browser_language	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Contacts	os	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Contacts	location	Struct	NA
Contacts	location_country	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Contacts	location_region	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Contacts	location_city	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Contacts	android_app_name	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Contacts	android_app_version	String	NA
Contacts	android_device	String	NA
Contacts	android_os_version	String	NA
Contacts	android_sdk_version	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Contacts	android_last_seen_at	날짜	NA
Contacts	ios_app_name	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Contacts	ios_app_version	String	NA
Contacts	ios_device	String	NA
Contacts	ios_os_version	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Contacts	ios_sdk_version	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Contacts	ios_last_seen_at	DateTime	NA
Contacts	custom_attributes	Struct	NA
Contacts	tags	Struct	NA
Contacts	notes	Struct	NA
Contacts	companies	Struct	NA
Contacts	unsubscribed_from_sms	불	NA
Contacts	sms_consent	불	NA
Contacts	opted_out_subscription_types	Struct	NA
Contacts	referrer	String	NA
Contacts	utm_campaign	String	NA
Contacts	utm_content	String	NA
Contacts	utm_medium	String	NA
Contacts	utm_source	String	NA
Contacts	utm_term	String	NA
Conversations	type	String	NA
Conversations	id	Integer	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	created_at	DateTime	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	updated_at	DateTime	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	source	Struct	NA
Conversations	source_id	String	EQUAL_TO, NOT_EQUAL_TO
Conversations	source_type	String	EQUAL_TO, NOT_EQUAL_TO,
Conversations	source_delivered_as	String	EQUAL_TO, NOT_EQUAL_TO,
Conversations	source_subject	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Conversations	source_body	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Conversations	source_author_id	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Conversations	source_author_type	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Conversations	source_author_name	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Conversations	source_author_email	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Conversations	source_url	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Conversations	contacts	Struct	NA
Conversations	teammates	Struct	NA
Conversations	제목	String	NA
Conversations	admin_assignee_id	Integer	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	team_assignee_id	Integer	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Conversations	custom_attributes	Struct	NA
Conversations	open	불	EQUAL_TO
Conversations	state	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Conversations	읽기	불	EQUAL_TO
Conversations	waiting_since	DateTime	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	snoozed_until	DateTime	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	tags	Struct	NA
Conversations	첫 번째_연락처_회신	Struct	NA
Conversations	priority	String	EQUAL_TO, NOT_EQUAL_TO
Conversations	topics	Struct	NA
Conversations	sla_applied	Struct	NA
Conversations	conversation_rating	Struct	NA
Conversations	conversation_rating_requested_at	DateTime	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	conversation_rating_replied_at	DateTime	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	conversation_rating_score	Integer	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	conversation_rating_remark	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Conversations	conversation_rating_contact_id	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Conversations	conversation_rating_admin_id	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Conversations	통계	Struct	NA
Conversations	statistics_time_to_assignment	Integer	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	statistics_time_to_admin_reply	Integer	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	statistics_time_to_first_close	Integer	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	statistics_time_to_last_close	Integer	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	statistics_median_time_to_reply	Integer	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	statistics_first_contact_reply_at	DateTime	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	statistics_first_assignment_at	DateTime	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	statistics_first_admin_reply_at	DateTime	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	statistics_first_close_at	DateTime	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	statistics_last_assignment_at	DateTime	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	statistics_last_assignment_admin_reply_at	DateTime	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	statistics_last_contact_reply_at	DateTime	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	statistics_last_admin_reply_at	DateTime	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	statistics_last_close_at	DateTime	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	statistics_last_closed_by_id	String	CONTAINS, EQUAL_TO, NOT_EQUAL_TO
Conversations	statistics_count_reopens	Integer	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	statistics_count_assignments	Integer	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	statistics_count_conversation_parts	Integer	EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN
Conversations	conversation_parts	나열	NA
데이터 속성	id	Integer	NA
데이터 속성	type	String	NA
데이터 속성	모델	String	NA
데이터 속성	name	String	NA
데이터 속성	full_name	String	NA
데이터 속성	레이블	String	NA
데이터 속성	설명	String	NA
데이터 속성	data_type	String	NA
데이터 속성	옵션	나열	NA
데이터 속성	api_writable	불	NA
데이터 속성	ui_writable	불	NA
데이터 속성	사용자 지정	불	NA
데이터 속성	archived	불	NA
데이터 속성	created_at	불	NA
데이터 속성	updated_at	DateTime	NA
데이터 속성	admin_id	String	NA
Segments	type	String	NA
Segments	id	String	NA
Segments	name	String	NA
Segments	created_at	DateTime	NA
Segments	updated_at	DateTime	NA
Segments	person_type	String	NA
Segments	count	Integer	NA
Tags	type	String	NA
Tags	id	String	NA
Tags	name	String	NA
팀	type	String	NA
팀	id	String	NA
팀	name	String	NA
팀	admin_ids	나열	NA

분할 쿼리

Spark에서 동시성을 활용하려는 경우 추가 Spark 옵션(PARTITION_FIELD, LOWER_BOUND, UPPER_BOUND, NUM_PARTITIONS)을 제공할 수 있습니다. 이러한 파라미터를 사용하면 Spark 태스크에서 동시에 실행할 수 있는 NUM_PARTITIONS개의 하위 쿼리로 원본 쿼리가 분할됩니다.

PARTITION_FIELD: 쿼리 분할에 사용할 필드의 이름입니다.
LOWER_BOUND: 선택한 파티션 필드의 하한 값(경계 포함).

날짜의 경우 Spark SQL 쿼리에 사용된 Spark 날짜 형식을 허용합니다. 유효한 값의 예제: "2024-02-06".
UPPER_BOUND: 선택한 파티션 필드의 상한 값(경계 제외).
NUM_PARTITIONS: 파티션 수.

엔터티 수준의 분할 필드 지원 세부 정보는 다음 표에 캡처되어 있습니다.

Entity Name	분할 필드	데이터 형식
Contacts	created_at, updated_at,last_seen_at	DateTime
Conversations	id	Integer
Conversations	created_at, updated_at	DateTime

예제


Intercom_read = glueContext.create_dynamic_frame.from_options(
    connection_type="Intercom",
    connection_options={
        "connectionName": "connectionName",
        "ENTITY_NAME": "conversation",
        "API_VERSION": "V2.5",
        "PARTITION_FIELD": "created_at"
        "LOWER_BOUND": "2022-07-13T07:55:27.065Z"
        "UPPER_BOUND": "2022-08-12T07:55:27.065Z"
        "NUM_PARTITIONS": "2"
    }
)

javascript가 브라우저에서 비활성화되거나 사용이 불가합니다.

AWS 설명서를 사용하려면 Javascript가 활성화되어야 합니다. 지침을 보려면 브라우저의 도움말 페이지를 참조하십시오.

문서 규칙

Intercom 연결 구성

Intercom 연결 옵션