# Intercom 엔터티에서 읽기
<a name="intercom-reading-from-entities"></a>

 **사전 조건** 
+  읽으려는 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"
    }
)
```