Documents
HomeAcademyContactInstallation Guide
User Manual
User Manual
  • Introduction & High Level Architecture
  • 200 OK Versions
    • Prerequisites
      • Internal Authentication Setup
      • Configuration for Email Threshold
    • Release Notes 200 OK Version 5.68.0
    • Release Notes 200 OK Version 5.36.0
    • Release Notes 200 OK Version 5.0.0
    • Release Notes 200 OK Version 4.26.0
    • Release Notes 200 OK Version 4.22.0
    • Release Notes 200 OK Version 4.6.0
    • Release Notes 200 OK Version 4.1.0
    • Release Notes 200 OK Version 3.47.0
    • Release Notes 200 OK Version 3.41.0
  • 200 OK UI Walkthrough
  • Access Configuration
  • Integration Channel
    • How to Create an Integration Channel.
    • Run Your Integration Channel: Let’s Make It Happen!
  • Integration Actions
    • Data Store
    • sObject
    • Apex Class
    • File
    • Platform Event
    • Quick Action
    • Global Action
    • Big Object
    • External Object
    • Integration Channel
    • Auto-launched Flow
    • Callback (client callback)
    • Custom Settings
    • Custom Metadata Type
    • Custom Label
    • Push Notification
  • ETL
    • Create Your ETL
      • Data Source
      • Transform
      • Load
      • Additional Features of ETL
  • Webhook
    • Setting Up Your Webhook!
    • Create Your Webhook!
    • Putting Your Webhook to the Test!
  • Invoke Integration Channel
    • Flow into Action: Invoking Your Integration Channel!
    • Unleash the Power: Invoke with Apex!
  • LWS
    • Transform Data on Demand: ETL as an API!
    • Supercharge Your Workflow: Invoke Integration Channel via API!
  • Built-in Functions
    • Text
      • getChar
      • extract
      • proper
      • len
      • trim
      • rightPad
      • leftPad
      • left
      • right
      • mid
      • getCharIndex
      • coalesce
      • toBoolean
      • toDecimal
      • split
      • replace
      • remove
      • toLowerCase
      • ascii
      • begins
      • capitalize
      • contains
      • deDuplicate
      • escapeHtml
      • generateRandomString
      • getValueFromResponseHeader
      • join
      • reverse
      • startCase
      • stripHtml
      • toBinaryBase64
      • toInt
      • toString
      • toUpperCase
      • escapeMarkDown
    • Math
      • abs
      • acos
      • asin
      • average
      • base64Decode
      • base64Encode
      • ceil
      • generateRandom
      • max
      • min
      • parseNumber
      • round
      • sum
      • switch
      • floor
    • Date & Time
      • toSeconds
      • daysBetween
      • dayPrecision
      • setHour
      • daysInMonth
      • dateTimeNow
      • netWorkDays
      • dateAdd
      • dateDiff
      • addMonths
      • date
      • dateTimeValue
      • dateValue
      • day
      • dayofYear
      • formatDate
      • formatDateToday
      • formatDateTodayFormat
      • formatDateTodayUnix
      • formatDateUnix
      • formatDateUnixFormat
      • toTime
      • toDate
      • toDateTime
      • toDateTimeUnix
    • Advanced
      • generateUUID
      • uncompress
      • compress
      • exists
      • dwTransform
      • discard
      • currencyRate
      • decodeUrl
      • encodeUrl
      • getChannelData
      • getLink
      • invokeFlow
      • invokeETL
      • lookup
      • md5
      • sha1
      • sha256
      • sha512
      • toJson
    • Logical
      • and
      • blankValue
      • case
      • if
      • isBlank
      • isNull
      • isNumber
      • not
      • nullValue
      • or
  • Custom Function
  • Filters for Integration Action
  • Data Mapping Types
    • Key/Value
    • JSON
  • Global variables for Data Mapping
    • Index
    • Record field
    • User
    • Organization
    • Custom Settings
    • Custom Metadata Type(MDT)
  • Advance Setting
  • Schedule
  • Utilities
    • Add Remote Site
    • Json To Apex
    • JSON parser invocable method
    • Export/Import Functionality
    • Import from Postman
    • Curl Import
    • Apex Class Template Creation for Header, Request and Response.
  • Logging
  • Monitor
    • Measure and track the usage
    • Integration channel (total active channels)
    • Callouts (total monthly callouts)
  • Most frequently used scenarios
    • Efficient Bulk Data Handling Using "!index"
    • How to access authentication data from a custom setting?
    • How to set up auth provider and named credentials?
    • How to use named credentials in an integration channel?
    • How to invoke integration channels from flow?
      • Screen flow
      • Record trigger flow
      • Platform event
      • Scheduled flow
    • How to set up a quick action with the integration channel flow?
Powered by GitBook
On this page
  1. Most frequently used scenarios

Efficient Bulk Data Handling Using "!index"

PreviousMost frequently used scenariosNextHow to access authentication data from a custom setting?

Last updated 7 months ago

To create multiple records from a JSON array in a single request, simply use the "!index" pattern in your response mapping. This allows you to easily map and create individual records for each item in the array!

Let us go with an example.

Let’s say you're processing multiple customer orders received from an e-commerce channel. Each order contains details such as OrderId, customer name, and the items purchased. You need to store OrderId in a system, and the "index" pattern can help map and store each order efficiently.

Below screenshots will help you how to provide the "!index" and store the data.

Before passing the "!index"

After passing the "!index"