• Partners
  • Email Us
  • Product
    • Channels
      • Voice
      • Email
      • SMS
      • Chat
      • Messenger
      • WhatsApp
      • Omnichannel
    • Features
      • Predictive Dialer
      • VCC Live Pay
      • Outbound IVR
      • Inbound IVR
      • Voicemail Detection
      • Live Dashboards
      • ACD
      • Salesforce Integration
      • Dialogflow
  • Solutions
    • Customer Service
    • Sales Teams
    • Debt Collection
    • Virtual Call Center
  • Pricing
  • Resources
    • Blog
    • Case Studies
    • Ebooks
    • Courses
    • Webinars
    • Information Security
    • Learning Center
    • Developers
  • Company
    • About us
    • Careers
    • News
    • Partners
  • Partners
  • Email Us
+44 208 638 0169
GET STARTED
Developer GuidesDatabase APIDatabaseBatch record modification
  • Overview
    • About Database API
    • The API location
    • Authentication and Security
    • Testing API
    • Request and Response
    • HTTP Response Codes
  • Examples
    • Hello World Example
    • Advanced Example
    • Web Callback Example
  • Reference
  • Project
    • List projects
    • List project outbound numbers
    • Get project parameters
    • Cloning projects
    • Get quota limits
    • Modify quota limits
  • Database
    • Add field and values
    • Add new value(s) to a field
    • Modify value(s) of a field
    • Delete a value
    • List records
    • Get detailed record information
    • Modify record
    • Modify contact
    • Add record
    • Add disposition
    • Batch record modification
    • Batch disposition modification
    • Add new value to Robinson list
    • Delete from Robinson list resource
  • Statistics
    • Dashboard API
    • Get CDR log
    • Get CDR log for a specified uuid
    • Get Email Log
    • Get voicefile for a specified CDR
    • Get inbound statistics
    • Get call statistics
    • User state log
    • User based statistics
    • User based model
    • Number of available agents in a queue
    • User's Current Status
  • Users
    • List users
    • Add new user
    • List teams
    • List all roles
    • User's Current Status
  • Archiver
    • Get the year and month when no voicefiles were archived
    • List all downloadable voice files in a given month
    • Set a successfully downloaded voicefile as archived
    • Download voice file
  • Campaign Manager
    • Get Database
    • Get Fields
    • Add Customer
    • Modify Customer
Back to Support and Learning Center
English Hungarian

Batch record modification

Modify multiple records in batch mode in a project.

If the value field (that can handle only one value) contains text, then:

  • it finds the field value based on the text input, and sets it (based on the id)
  • if it does not find the field value, then it automatically creates a new field value

If the value field (that can handle more than one values) contains text, then:

  • it attempts to divide the text separated by the “|” character
  • if it doesn’t find any “|” character, then it handles it as one value

The followings apply to each separated values:

  • it finds the field value based on the text input, and sets it (based on the id)
  • if it does not find the field value, then it automatically creates a new field value

Note: There is no limit on how many batches you can submit to update. If it fails due to timeout, please try to limit the query to fewer data.

Request
Method PUT
Resource https://[customer].asp.virtual-call-center.eu/v2/projects/[projectid]/records
Options N/A
Body Customised data, encoded in JSON.
Response
Body Array of partial results by elements.

Request

Resource parameters

Name Type Mandatory Comment
customer string yes Your call centre’s unique identifier (subdomain).
projectid integer yes Unique project identifier.

Request object

Name Type Mandatory Comment
default object no Key value pairs that should be set for every record, specified by an ‘element’ object.
elements array of objects yes Array of element objects to be set.

Element object

Name Type Mandatory Comment
form object yes Custom data fields to be set as key value pairs.
numberid string yes/no Unique record identifier specifying a record to be set. Either ‘search’ or ‘numberid’ can be set.
search object yes/no Specifies a record to which key value pairs should be applied to. Either ‘search’ or ‘numberid’ can be set.

Response

Array of partial results by elements.

Example

URL: https://mycc.asp.virtual-call-center.eu/v2/projects/22/records

Request body

{
    "elements": [
        {
            "form": {
                "name": "Peter Green",
                "city": "Budapest",
                "likes": "sports|movies"
            },
            "search": {
                "name": "Green"
            }
        },
        {
            "form": {
                "name": "Thomas",
                "address": "London"
            },
            "numberid": "4"
        }
    ],
    "default": {
        "address": "Budapest",
        "age": "30"
    }
}

Response body

{
    "errors": [],
    "response": {
        "0": true,
        "1": true
    }
}

Response body if partially succesful

{
    "errors": [
        {
            "errorcode": 417,
            "errormessage": "error.missing_numberid_or_search",
            "index": 1
        }
    ],
    "response": {
        "0": true,
        "2": true
    }
}
Back to Support and Learning Center

Comments

Can’t find what you need? Use the comment section below to connect with others, get answers from our experts, or share your ideas with us.


There are no comments yet.

Click here to cancel reply.

Please note that by clicking on the Submit button, you agree to a member of VCC Live team contacting you with business offers. You can find detailed information on how we can establish contact with you in our Privacy Policy

  • Channels
    • Voice
    • Email
    • SMS
    • Chat
    • Messenger
    • Omnichannel
  • Main Features
    • Call Center Software
    • Predictive Dialer
    • VCC Live Pay
    • Outbound IVR
    • Inbound IVR
    • Voicemail Detection
    • Live Dashboards
    • ACD
    • Salesforce Integration
    • Dialogflow
  • Solutions
    • Customer Service
    • Sales Teams
    • Debt Collection
    • Virtual Call Center
  • Resources
    • Blog
    • Case Studies
    • Ebooks
    • Courses
    • Webinars
    • Information Security
    • Learning Center
    • Developers
    • Download
  • Company
    • About us
    • Careers
    • News
    • Partners
https://vcc.live/wp-content/uploads/2019/07/iso-cert-1.png https://vcc.live/wp-content/uploads/2019/07/iso-cert-2.png https://vcc.live/wp-content/uploads/2019/07/iso-cert-3.png
Social Media
https://vcc.live/wp-content/uploads/2019/07/linkedin.svg https://vcc.live/wp-content/uploads/2019/07/twitter.svg https://vcc.live/wp-content/uploads/2019/07/facebook-1.svg https://vcc.live/wp-content/uploads/2019/07/instagram-1.svg
Call us
Hungary
+36 19996400
UK
+44 2086380169
Germany
+49 3021782516
Poland
+48 123950886
Romania
+40 31706167
USA
+1 3024988337
Hungary
+36 19996400
UK
+44 2086380169
Germany
+49 3021782516
Poland
+48 123950886
Romania
+40 31706167
USA
+1 3024988337
  • Privacy Policy
  • Cookie Policy
  • Legal Statement
  • General Terms of Agreement
  • Magyar nyelvű jogi dokumentumok