Picky Assist Help Desk
Main WebsiteBlogFacebook Community
Picky Assist Help Desk
Picky Assist Help Desk
  • Welcome To Picky Assist 🙏
  • Setting Up Guide
    • Sending First Message
    • Connecting Channels
      • WhatsApp Web Automation to Official API Migration Guide 2024
      • Connecting WhatsApp Web Automation
      • Connecting Facebook Messenger
        • Introduction
        • Getting Start
        • Guidelines & Compliances
        • Messenger Link
      • Connecting WhatsApp Official
        • Introduction
        • Dashboard
        • Profile
        • Templates
      • Connecting WhatsApp Cloud API
      • WhatsApp Official Managed Service
      • Connecting Instagram
      • Phone Bridge (Call Blaze)
      • Connecting SMTP
      • Connecting Amazon SES
      • Connecting Sendgrid
      • Connecting Additional WhatsApp Numbers
      • Porting WhatsApp Number to Picky Assist
      • WhatsApp Official Message Delivery Issues & Solutions
    • Working With Prebuilt CRM Modules
      • Introduction
      • Onboarding
      • Modules
        • Leads
        • Deals
        • Meetings
        • Company
        • Support Cases
        • System Modules
          • Contacts
          • Notes
          • Task
          • Call Logs
          • Tags
          • Activity Logs
      • Automations
        • Workflows
        • Chatbots
        • Funnels
        • Connectors
        • Scheduler
        • Other Prebuilt Features
      • Reports and Dashboard
      • Mandatory Preconditions for Using Prebuilt
      • Testing Prebuilt
    • Managing Organization
    • Setting Up Teambox
      • Introduction
      • Routing Rules
      • Teambox
      • Inbox View
      • Organization Hierarchy
      • Analytics
    • Setting Up Smart Replies
      • Introduction
      • Train Module
        • Training Bot Introduction
        • Topics / Categories
        • Intent & Context
        • Question Variations
        • Uploading Bulk Questions
        • Reply with Media Files
        • Personalising Replies
        • Smart Actions
        • Direct URL
        • Fall Back Response
        • Small Talks
        • Testing the Bot
        • Publishing Bot
      • ChatGPT Integration
      • Learn Module
      • Stats Module
      • Deep Linking
      • Settings
    • Smart Reply V2
      • Introduction
      • ChatGPT Integration
      • Train Module
        • Training Bot Introduction
        • Topics / Categories
        • Intent & Context
        • Question Variation
        • Uploading Bulk Questions
        • Reply with Media Files
        • Personalizing Replies
        • Smart Actions
        • Direct URL
        • Fall Back Response
        • Small Talks
        • Publishing Bot
      • Learn Module
      • Stats Module
      • Deep Linking
      • Settings
    • Setting Up Broadcaster
      • Introduction
      • Creating a Campagin
      • Sending Message to WhatsApp Groups
      • Reports
      • Broadcaster V2
        • Introduction
        • Creating Campaign
        • Reports
    • Setting Up Sequence
      • Introduction
      • Creating New Sequence
      • Sequence Stats
      • Subscribe & Unsubscribe
      • Disabling Sequence Message
    • Setting Up Reminder
    • Setting Up Mobile App
    • Setting Up Connector
      • Introduction
      • Getting Started
      • Steps
        • Introduction
        • Filters
        • Delay
        • Iterator
        • Stats
      • Actions
      • Formatter
        • Date & Time
        • Counter
        • Math Calculation
        • Data Parser
        • Convert File
        • Line Items
      • Building Mini App
      • Email Parser
      • Data Storage
      • Simulate Test
      • Connector Logs
    • Email Builder
    • Setting Up Flow Builder
      • Fundamentals (Must Read)
      • Basic Terminology (Must Read)
      • Guide to Building an Effective Chatbot (Must Read)
      • Create, Manage, Test & Publish Flows
      • Triggering a Chatbot Flow
      • Steps
        • Introduction (Must Read)
        • Send Message
        • Ask A Question
        • Filter
        • Save Data
        • Actions
        • Check WhatsApp Session
        • Delay
        • Smart Delay
        • Formatter
        • Splitter
        • Data Lookup
        • Trigger HTTP API
        • Webhook
        • Apps
        • Match Keywords
        • Route to Chatbot
        • End
      • Saving Data into CRM
      • Analytics
      • Integrations
      • Flow Builder logs and conversational logs
      • Chatbot Best Practices, Ideas & FAQ
    • Setting up Modular CRM
      • Fundamentals (Must Read)
      • Guide to Building and Implementing a Modular CRM (Must Read)
      • Create & Manage Data Modules
      • CRM Macro Buttons
      • Adding Records into CRM
      • Data View & Manage Records
      • Task
      • Workflows
      • Funnels
      • Data Import
      • Integrations
    • Setting Up Scheduler
    • Media Gallery
    • Quick Replies
    • Opt-out Settings
    • Blacklist
    • Global Variables
    • Setting Up Ad-On's
      • Setting Up WhatsMail
      • Setting Up Zendesk
      • Setting Up Zapier
      • Setting Up Zoho CRM
        • Getting Started
        • Working with Extension
        • Integrating with Zoho Workflow
        • Lead Assignment Rules
        • Integrating into Custom Modules
        • Connecting Multiple WhatsApp Numbers into Zoho CRM
        • Integrating WhatsApp with Zoho CRM Mobile App
        • Keyboard Shortcuts
      • Setting Up Facebook Lead Adform
      • Facebook Lead Ad form V2
      • Setting Up WhatsApp Web
      • Setting Up Pabbly Connect
      • Setting Up ChatGPT App
    • Google Chrome Extensions
      • Extension for Sending WhatsApp Messages from any Webpage
      • Chrome Extension V2
      • Extension for Zoho CRM & Teambox
    • Managing Profile
      • Two Factor Aunthentication
      • Login History
      • Delete Account
    • Quick Rollout Guide
      • WhatsApp Official Account
    • Developers & Partners Guide for Deep Integration of Picky Assist
  • API Documentation V2
    • Introduction
    • Quick Start Guide 🏃
    • Global Webhook
      • How Webhook Works
      • Webhook Variables
      • Configuring Webhook URL
      • Webhook Request & Response
      • Getting the Conversation Context
      • Testing Your Webhook
    • Event Webhook
      • How Event Webhook Works
      • Event Webhook Variables
      • Configuring Event Webhook URL
      • Event Webhook Sample Request & Response
    • Push API
      • Introduction
      • API Variables
      • Sending Single Message - Push
      • Sending Dynamic Messages – Push
      • Sending Media Attachments – Push
      • Sending Interactive List & Buttons
      • Sending Stickers
      • Sending Bulk Messages - Push
      • Sending Contacts
      • Sending Location
      • Sending WhatsApp Template Messages
        • Introduction
        • Sending WhatsApp Template Text Messages
        • Sending WhatsApp Template Image
        • Sending WhatsApp Template Document
        • Sending WhatsApp Interactive Buttons
        • Sending WhatsApp Limited Time Offer Templates
      • Sending Message to Groups
      • Sending SMS Using SIM Card
      • Sending Message to Facebook Messenger
      • Normal Post Method
      • Delivery Reports
      • Push API Must Read Instructions
      • Testing API Requests
    • WhatsApp Template API
      • Introduction
      • API Variables
      • Template Request API
      • Template Status API
      • Languages
      • Guidelines
    • WhatsApp Group API
      • Introduction
      • API Variables
      • Create Group
      • Set Group Permission
      • Add Group Admin
      • Add Group Members
      • Fetch Group Details
      • Update Group Info
      • Remove Group Members / Admin
      • Generate New Invite Link
      • Group Delete Actions
    • WhatsApp Settings API's
      • WhatsApp Profile API
      • 2 Step Verification
      • WhatsApp Status Update
      • WhatsApp Contact & Group Fetching
    • Device Manage API’s
      • Fetching Device Status API
      • Device Commands API’s
      • WhatsApp Automation Server Status API
    • Account API
      • Fetch Balance
    • Project Management API
      • Introduction
      • Create Project
      • Get Project Details
      • Set / Update Webhook
      • Create API Token
      • Manage API Token
      • Change Billing Plan
      • Fetch Account Balance
      • Country Code & Timezones
    • References
      • Status & Error Codes
      • Most Frequent Issues & Solutions
      • Formating & Sending Emojis 😊
      • Postman Collection for Picky Assist API's
      • High Volume Messaging Bots - WhatsApp
    • Sample Codes
      • PHP
      • Python
      • Node JS
      • Ruby
      • Java
      • ASP.NET Using C#
      • Javascript
      • Go
      • Swift
      • C
      • C#
      • Objective C
  • General Guidelines
    • Billing
    • Adding Money Into Account
    • Rate Limits
    • Character Limits WhatsApp
    • Best Practices for Media Handling
    • Roadmap
    • Features In the Early Beta Version
  • Changelog
    • 2021
      • February 2021
      • March 2021
      • April 2021
      • May 2021
      • June 2021
    • 2020
      • February 2020
      • March 2020
      • April 2020
      • May 2020
      • June 2020
      • September 2020
      • October 2020
    • 2019
      • November 2019
      • October 2019
      • August 2019
      • September 2019
Powered by GitBook
On this page
  • Getting Started
  • Add New Record
  • Search Record
  • Update Record
  • Delete Records

Was this helpful?

  1. Setting Up Guide
  2. Setting Up Flow Builder
  3. Steps

Data Lookup

PreviousSplitterNextTrigger HTTP API

Last updated 6 months ago

Was this helpful?

The "Data Lookup" step is particularly useful when you are using Picky Assist CRM to manage your business. It allows you to search for specific details within existing CRM modules and retrieve the results to provide as a message to the end user. Additionally, you can also use this step to add a new record to another module within the CRM.

With the "Data Lookup" step, you can leverage the power of your CRM by accessing and retrieving relevant information to enhance the conversational experience with your users. This step enables you to dynamically retrieve and display data based on user inputs or other criteria, providing personalized and accurate responses.

Getting Started

You need to select the module to which you want to perform an action and then select the action type, we have 4 action types

Add New Record : This will add a new record to the selected module i.e a new row will be added

Search Record: This will search the record based on the given criteria and returns the search results

Update Record : This will update one or many records based on the given criteria

Delete Record : This will delete the entire row in a module as per the given criteria

Add New Record

This will add a new record to the selected module by creating a new row using the data given by you, you can easily map the data from the users input into the respective fields as shown below, you can add more fields by clicking the "Add New Field" as shown below

There is an option to select whether any workflow associated with that module should be triggered or not as part of adding a new record. By default, it won't trigger the workflow however if you uncheck then any workflow associated with the respective module will be triggered.

There is also an option whether to allow partial data save or not, this helps you to create a new record even if the required fields are missing.

Search Record

This feature allows you to search records based on given criteria and return the search results. Here are some use cases you can achieve with 'Search Record':

  1. Check Deal Status : When a contact initiates a chat, you can perform a search for specific information in a module and progress the step accordingly. For instance, you may want to check the 'Deal' module to see if there are any open deals for that particular contact.

  2. During a checkout process, if you need to confirm the contact's address saved in a different module (e.g., 'Address'), you can fetch all addresses that match the contact. These addresses can then be presented back to the user in the chat for them to choose one, in case multiple accounts are found.

  3. Personalized Marketing: If you've stored customer preferences in a separate module, you can use the 'Search Record' function during a marketing interaction. By fetching these preferences, you can tailor the conversation to fit the customer's likes and dislikes, making your marketing more effective.

  4. Order Tracking: If a customer inquires about their order status, you can use the 'Search Record' function to check their order details in the 'Orders' module. You can then provide them with up-to-date information about their order.

  5. Upselling/Cross-selling: If you have a module that keeps track of what products or services a customer has purchased or shown interest in, you can use 'Search Record' during a conversation to suggest related items they might find useful or interesting.

  6. Customer Segmentation: If you've categorized your customers into different segments, you can use 'Search Record' to identify which segment a contact belongs to during an interaction. This way, you can ensure the conversation is tailored to their specific segment, leading to more personalized and effective communication.

  7. Appointment Scheduling: If your business involves appointments or reservations, 'Search Record' can be used to look up a customer's past and future appointments. This allows you to avoid scheduling conflicts and ensure the customer has the most convenient timing for their appointments.

  8. Membership Status: If you run a membership or subscription service, 'Search Record' can fetch a customer's membership status, expiration date, and other related information. This way, you can remind them about upcoming renewals, inform them about benefits they're eligible for, or even offer upgrades based on their membership history.

  9. Payment History: For financial queries or disputes, 'Search Record' can fetch a customer's payment history. This can help quickly resolve any confusion about payments, refunds, or charges.

  10. Feedback Tracking: If you have a system for collecting customer feedback or reviews, 'Search Record' can fetch a specific customer's feedback history. This can give you insights into their satisfaction levels over time, their common complaints or praises, and areas of your service that they particularly value.

To search data from the module, add the Data Lookup step then select the Module to which the search to be performed then click on the Select Action as Search Record as shown below

Select the module field you wish to perform the search, if you want to do a full-text search then select "Any Field" and this will search the entire record with the given value

Based on the data field type selected the system will provide you with the different filter conditions, you can pass the dynamic value from the previous step or even from the 3rd party app that is saved in the HTTP API step using the attribute feature as shown below

Now, to broaden or narrow your search, you need to provide the following information:

  1. Limit Search by Rows: This option allows you to instruct the system to limit the number of rows fetched from the system. Please note that the maximum records that can be extracted from a single search query is limited to 10,000.

  2. Sorting Field: This helps you to determine based on which module field the data should be sorted. For example, you might want to sort based on 'Modified Date'.

  3. Sorting Order: You can instruct the system how to order the search results. This can be either Ascending (Oldest Data First) or Descending (Newest Data First).

  4. Save Response to Variable: This option allows you to save the search result to a variable. The result will be in JSON format, which can be further used in the 'Picky Assist Formatter -> Line Items' function.

Important Notes on Search:

  1. A single search result can retrieve a maximum of 10,000 records.

  2. The search result is available as a JSON request for developers, allowing them to perform advanced actions or push the data to a 3rd party platform.

  3. To perform an exact search, you need to pass the record id or ensure that the search record field is unique. For example, if a module has unique mobile numbers, you can query a search by mobile number, and it will yield only one output. This output can be further used in the attribute.

  4. Please note that if the search result yields more than one record, you must use 'Formatter -> Line Items' to process them. If you directly use the attributes, only the first record in the search result can be passed using the attribute value.

See how the Search result shows in the attribute, you can see the Variable name and bracket the module name as shown below

Update Record

The 'Update Record' feature allows you to modify one or many records saved in the Picky Assist Modular CRM modules. Here are a few use cases you can create with Update Record:

  1. Feedback Update : When feedback is collected, update the respective module record with the new data.

  2. Payment Status Update : When a payment is captured in the flow, update the payment details in the corresponding order module data fields.

  3. Membership Renewal: Update the membership status and renewal date of a customer when they renew their subscription through a chatbot conversation.

  4. Updating Contact Information: If a customer provides updated contact information (e.g., a new phone number or email address), you can use 'Update Record' to update this information in your CRM.

  5. Order Status Change: If an order status changes (for example, from 'processing' to 'shipped'), you can update this status in your CRM to keep accurate records.

  6. Tracking Customer Preferences: As customers provide information about their preferences (such as favorite products or desired communication frequency), you can update these details in your CRM.

  7. New Appointments: If a customer books an appointment or reservation, you can update this in your CRM, ensuring that all information stays up-to-date.

  8. Task Completion: If a customer completes a task or a milestone within a bigger process (e.g., completing a training module), you can use 'Update Record' to mark this task as completed in your CRM.

  9. Lead Status Updates: As a lead moves through your sales funnel (from prospect to lead to customer), you can use 'Update Record' to update their status in your CRM.

  10. Customer Support Resolution: After resolving a customer support ticket, use 'Update Record' to update the ticket status to 'resolved' and note any important details about the resolution.

To update a record add the "Data Lookup" step into Canvas then select the module in which you need to perform Data Lookup then click the action "Update Record" as shown below;

There is an option to select whether any workflow associated with that module should be triggered or not as part of updating a record. By default, it won't trigger the workflow however if you uncheck then any workflow associated with the respective module will be triggered.

Select the module field you would like to update, search the field by name or perform a search in the entire module then click on Any Field

It's possible to search a field by its Record ID and update data fields within that module. By default, the current Record ID of the flow CRM module is always available in the attribute, as illustrated below:

Now, to broaden or narrow your search, you need to provide the following information:

  1. Limit Search by Rows: This option allows you to instruct the system to limit the number of rows fetched from the system. Please note that the maximum records that can be extracted from a single search query is limited to 10,000.

  2. Sorting Field: This helps you to determine based on which module field the data should be sorted. For example, you might want to sort based on 'Modified Date'.

  3. Sorting Order: You can instruct the system how to order the search results. This can be either Ascending (Oldest Data First) or Descending (Newest Data First).

Now you need to select the data fields and map the value that needs to be updated as shown below, you have the following options

  1. Click the Module field to select the field that needs to be updated

  2. Then map the value from the attribute dynamically or enter manually in the given text box

  3. Check whether you want to update the field if the value is existing

To add more fields click on "Add More Field" and repeat the steps

Important Notes on 'Update'

  1. Up to 10,000 records can be updated in a single execution.

  2. To update a specific field in the module, you need to pass the Record ID or ensure that the search record field is unique. For example, if a module has unique mobile numbers, you can perform a search query using the mobile number, and subsequently update the mobile number or any other fields in that module.

Please note: If your module doesn't contain a unique field, you might inadvertently update multiple records with the same non-unique information. Be cautious to avoid this potential issue.

Delete Records

This feature allows you to delete one or many records from the selected module. This is useful for removing data that are no longer needed, helping to keep your CRM clean and uncluttered.

The 'Delete Records' function operates in the same way as the 'Update Record' function explained earlier. Instead of updating the record, it will simply delete the row that matches the given condition.

Please note that this action will delete the entire row, meaning all data fields associated with that specific row in the module will be removed. Therefore, when utilizing this action, please ensure that your filter condition is accurate, as it can delete multiple records at once. For example, if your search condition is a tag labeled 'vip', and you perform the delete action, all records mapped with the 'vip' tag will be deleted from the selected module.

To delete a record add the "Data Lookup" step into Canvas then select the module in which you need to perform Data Lookup then click the action "Delete Record" as shown below;

Select the module field you would like to update, search the field by name or perform a search in the entire module then click on Any Field

Now, to broaden or narrow your search, you need to provide the following information:

  1. Limit Search by Rows: This option allows you to instruct the system to limit the number of rows fetched from the system. Please note that the maximum number of records that can be extracted from a single search query is limited to 10,000.

  2. Sorting Field: This helps you to determine based on which module field the data should be sorted. For example, you might want to sort based on 'Modified Date'.

  3. Sorting Order: You can instruct the system on how to order the search results. This can be either Ascending (Oldest Data First) or Descending (Newest Data First).

Important Notes on 'Delete'

  1. Up to 10,000 records can be deleted in a single execution.

  2. To delete a specific field in the module, you need to pass the Record ID or ensure that the search record field is unique. For example, if a module has unique mobile numbers, you can perform a search query using the mobile number, and subsequently delete the rows that match the mobile number value

Please note: If your module doesn't contain a unique field, you might inadvertently delete multiple records with the same non-unique information. Be cautious to avoid this potential issue.