SSIS Components for Google Ads

Build 24.0.9062

LocalServicesVerificationArtifact

A local services verification resource.

Columns

Name Type Behavior Description
CustomerId Long ATTRIBUTE Output only. The ID of the customer.
LocalServicesVerificationArtifactArtifactType String ATTRIBUTE Output only. The type of the verification artifact.

使用できる値は次のとおりです。BACKGROUND_CHECK, BUSINESS_REGISTRATION_CHECK, INSURANCE, LICENSE, UNKNOWN, UNSPECIFIED

LocalServicesVerificationArtifactBackgroundCheckVerificationArtifactCaseUrl String ATTRIBUTE Output only. URL to access background case.
LocalServicesVerificationArtifactBackgroundCheckVerificationArtifactFinalAdjudicationDateTime Datetime ATTRIBUTE Output only. The timestamp when this background check case result was adjudicated. The format is 'YYYY-MM-DD HH:MM:SS' in the Google Ads account's timezone. Examples: '2018-03-05 09:15:00' or '2018-02-01 14:34:30'
LocalServicesVerificationArtifactBusinessRegistrationCheckVerificationArtifactCheckId String ATTRIBUTE Output only. The id of the check, such as vat_tax_id, representing 'VAT Tax ID' requirement.
LocalServicesVerificationArtifactBusinessRegistrationCheckVerificationArtifactRegistrationDocumentDocumentReadonlyDocumentUrl String ATTRIBUTE URL to access an already uploaded Local Services document.
LocalServicesVerificationArtifactBusinessRegistrationCheckVerificationArtifactRegistrationNumberNumber String ATTRIBUTE Output only. Government-issued number for the business.
LocalServicesVerificationArtifactBusinessRegistrationCheckVerificationArtifactRegistrationType String ATTRIBUTE Output only. The type of business registration check (number, document).

使用できる値は次のとおりです。DOCUMENT, NUMBER, UNKNOWN, UNSPECIFIED

LocalServicesVerificationArtifactBusinessRegistrationCheckVerificationArtifactRejectionReason String ATTRIBUTE Output only. Registration document rejection reason.

使用できる値は次のとおりです。BUSINESS_DETAILS_MISMATCH, BUSINESS_NAME_MISMATCH, DOCUMENT_EXPIRED, DOCUMENT_INVALID, DOCUMENT_TYPE_MISMATCH, DOCUMENT_UNVERIFIABLE, ID_NOT_FOUND, OTHER, POOR_DOCUMENT_IMAGE_QUALITY, UNKNOWN, UNSPECIFIED

LocalServicesVerificationArtifactCreationDateTime Datetime ATTRIBUTE Output only. The timestamp when this verification artifact was created. The format is 'YYYY-MM-DD HH:MM:SS' in the Google Ads account's timezone. Examples: '2018-03-05 09:15:00' or '2018-02-01 14:34:30'
LocalServicesVerificationArtifactId Long ATTRIBUTE Output only. The ID of the verification artifact.
LocalServicesVerificationArtifactInsuranceVerificationArtifactAmountMicros Long ATTRIBUTE Output only. Insurance amount. This is measured in 'micros' of the currency mentioned in the insurance document.
LocalServicesVerificationArtifactInsuranceVerificationArtifactExpirationDateTime Datetime ATTRIBUTE Output only. The timestamp when this insurance expires. The format is 'YYYY-MM-DD HH:MM:SS' in the Google Ads account's timezone. Examples: '2018-03-05 09:15:00' or '2018-02-01 14:34:30'
LocalServicesVerificationArtifactInsuranceVerificationArtifactInsuranceDocumentReadonlyDocumentUrl String ATTRIBUTE URL to access an already uploaded Local Services document.
LocalServicesVerificationArtifactInsuranceVerificationArtifactRejectionReason String ATTRIBUTE Output only. Insurance document's rejection reason.

使用できる値は次のとおりです。BUSINESS_NAME_MISMATCH, CATEGORY_MISMATCH, EDITABLE_FORMAT, EXPIRED, INSURANCE_AMOUNT_INSUFFICIENT, MISSING_EXPIRATION_DATE, NON_FINAL, NO_COMMERCIAL_GENERAL_LIABILITY, NO_POLICY_NUMBER, NO_SIGNATURE, OTHER, POOR_QUALITY, POTENTIALLY_EDITED, UNKNOWN, UNSPECIFIED, WRONG_DOCUMENT_TYPE

LocalServicesVerificationArtifactLicenseVerificationArtifactExpirationDateTime Datetime ATTRIBUTE Output only. The timestamp when this license expires. The format is 'YYYY-MM-DD HH:MM:SS' in the Google Ads account's timezone. Examples: '2018-03-05 09:15:00' or '2018-02-01 14:34:30'
LocalServicesVerificationArtifactLicenseVerificationArtifactLicenseDocumentReadonlyDocumentUrl String ATTRIBUTE URL to access an already uploaded Local Services document.
LocalServicesVerificationArtifactLicenseVerificationArtifactLicenseNumber String ATTRIBUTE Output only. License number.
LocalServicesVerificationArtifactLicenseVerificationArtifactLicenseType String ATTRIBUTE Output only. License type / name.
LocalServicesVerificationArtifactLicenseVerificationArtifactLicenseeFirstName String ATTRIBUTE Output only. First name of the licensee.
LocalServicesVerificationArtifactLicenseVerificationArtifactLicenseeLastName String ATTRIBUTE Output only. Last name of the licensee.
LocalServicesVerificationArtifactLicenseVerificationArtifactRejectionReason String ATTRIBUTE Output only. License rejection reason.

使用できる値は次のとおりです。BUSINESS_NAME_MISMATCH, EXPIRED, OTHER, POOR_QUALITY, UNAUTHORIZED, UNKNOWN, UNSPECIFIED, UNVERIFIABLE, WRONG_DOCUMENT_OR_ID

LocalServicesVerificationArtifactResourceName String ATTRIBUTE Immutable. The resource name of the Local Services Verification. Local Services Verification resource names have the form: customers/{customer_id}/localServicesVerificationArtifacts/{verification_artifact_id}
LocalServicesVerificationArtifactStatus String ATTRIBUTE Output only. The status of the verification artifact.

使用できる値は次のとおりです。CANCELLED, FAILED, NO_SUBMISSION, PASSED, PENDING, UNKNOWN, UNSPECIFIED

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
ManagerId Long Id of the manager account on behalf of which you are requesting customer data.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062