Tableau Connector for Google Contacts

Build 24.0.9060

UpdateOrDeleteContactPhoto

Update or Delete a contact's photo.

Stored Procedure Specific Information

Process of Update or Delete Contact Photo

GoogleContacts allows only a small subset of columns to be used in the EXEC query. These columns can typically be used with only = comparison. The available columns for UpdateOrDeleteContactPhoto are Id, Action, FileSource and Url.

Note: Id is required column. The Action attribute defines the operation to perform. The supported operators are 'UPDATE, Delete' for Action. You need to specify either FileSource or URL to update the contact photo. For example:

EXECUTE UpdateOrDeleteContactPhoto Id = 'c2845916184580148264', Action = 'Update', FileSource = 'D:\GooglePeople_API_Outputs\contactphoto.png'

EXECUTE UpdateOrDeleteContactPhoto Id = 'c2845916184580148264', Action = 'Update', Url = 'https://play-lh.googleusercontent.com/-Xqd3k7aJqZY/AAAAAAAAAAI/AAAAAAAAAAA/AMZuuckWFzqX627ygMhiilKbqmIA-T_AsQ/photo.jpg'

EXECUTE UpdateOrDeleteContactPhoto Id = 'c2845916184580148264', Action = 'Delete'

Input

Name Type Required Description
Id String True The Id of the contact.
Action String True Update or Delete operation you want to perform on Contact Photo. Possible values: Update, Delete
FileSource String False The complete filepath of the photo to be uploaded. You need to specify either this field or URL.
URL String False An accessible URL the image will be downloaded from and then posted to the target. You need to specify either this field or FileSource.

Result Set Columns

Name Type Description
Success String Returns True if contact group has been modified.

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