Jeremy_MONZO | 2021-07-23 12:44:36 UTC | #1
Hello,
I would like from a script inbound call makes a query, for example make a query like "all customer living in France" from a Excel File contained the data. My first idea was to create a datatable with the import data from my Excel File, but I cannot find a API, which can query only a specific field on my file, I have checked also with contact list id, but I can only filter with contactId. My goal is to avoid to use a webservice for query directly into a database (where CSV file has been integrated).
Any Hints? Thanks
Jason_Mathison | 2021-07-23 13:20:05 UTC | #2
Hi Jeremy,
I am not an expert on datatables or contact lists, so I don't know if there is a way there to do what you want. If you can't find a solution using those tools you might consider creating a lambda / lambda data action that can process the excel file and answer your questions. That would eliminate creating and maintaining a full fledged webservice and database.
--Jason
Jerome.Saint-Marc | 2021-07-23 13:49:16 UTC | #3
Hello Jeremy,
As Jason wrote above, you will have to leverage a WebServices or Lambda or Google Data Action.
Architect Data Tables do not allow a search using a field/column of the table (to bring back multiple results). Each row has a primary key (single key/identifier) and can only be queried based on this primary key. Otherwise you have to scan/retrieve all rows from the table. It is a NoSQL database/approach.
Regarding the Outbound Calling List (i.e. Contact List), it is not possible to retrieve contacts based on a custom field that would contain the country name. You need the contactId or scan the contact list entries.
Regards,
Jeremy_MONZO | 2021-07-23 15:18:32 UTC | #4
Thanks guys for your tips!
system | 2021-08-23 15:18:35 UTC | #5
This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.
This post was migrated from the old Developer Forum.
ref: 11562