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. Integration Actions

Data Store

PreviousIntegration ActionsNextsObject

Last updated 5 months ago

In 200 OK, the Datastore, also known as Platform Cache, functions as a specialized storage area for frequently accessed data within your 200 OK application. It works like a super-fast memory system for 200 OK, making data easy to grab when needed.

Example :-

You are bringing data from one ERP, the account receivables from a customer every night. We are not interested to store all the data in Salesforce, rather, the data needs to be passed in another job which is going to execute after one hour to send to another system for reporting purpose. So, Salesforce provides a Platform Cache where you can keep the data for certain period of time. Once the data has been retrieved or read, it can automatically disappear or you can still keep it for other purposes by specifying the time to live.

How to create and use the Data Store in the 200 OK.

We have to enable the platform cache in the org.

To enable Platform Cache:

  1. Click on the setup gear icon at the top right corner.

  2. Go to the Home tab.

  3. Use the quick find feature to search for 'Platform Cache'.

  1. In the Platform Cache, you'll find a label called '200 OK' and the allocated capacity is currently set to 0.

  1. Click on the edit and change the allocated capacity to "3" in the Organization field under the section of Org Cache Allocation and save it.

  1. Create the Integration Channel by providing the required details click on the Action tab next to the Integration.

  1. On click the Action we can see Add New Action click on that it will show the list of actions .

  1. Select the Data Store action form the list.

  1. Label the Data Store as required and provide the data in the field and value which you want to store.

  2. Once the data is passed in key-value format. Click on save and execute the channel. The Data will be saved for temporary storage in the platform cache.

  1. We are also providing time to live (TTL) feature in data store. Using this feature, the user can store the data for given time frame after that data will cleared from data store.

  2. To set up the TTL click on the Advance Settings and provide the value in the TTL and save the advance settings.

How to get the Stored Value.

  1. To get the stored data we have one function called getDataStoreValue. By using this function we can get the data and use it as we required.

  1. User can also provide TTL in getDataStoreValue function. getDataStoreValue has one required parameter and one optional parameter.

  2. The first parameter is key which is required for this function and the second parameter is TTL value which is optional.

  3. Users can provide TTL value in seconds. The minimum TTL value is 300 if third parameter is empty then. After getting the data it will deleted automatically.

Note: - This feature is designed for handling small data sizes, so please refrain from storing large JSON datasets.

By this we are concluding how to store and retrieve data with ease.