Outcode User Guide
Developers GuideSales Contacts
English
English
  • WHAT IS OUTCODE?
    • Introduction
    • Getting Start
    • FAQ (3 Minutes)
    • Differences
  • Apps
    • API
      • Actions
        • HTTP Request
      • Trouble Shootings
    • JavaScript
      • Actions
        • Function Execution
      • Trouble Shootings
    • Data Source
      • MySQL
        • Connection
        • Actions
          • Query
        • Trouble Shootings
      • PostgreSQL
        • Connection
        • Actions
          • Query
        • Trouble Shootings
      • MongoDB
        • Connection
        • Actions
          • Find Documents
          • Aggregation
          • Insert Single Document
          • Update Single Document
          • Delete Single Document
        • Trouble Shootings
      • Airtable
        • Connection
        • Actions
          • Webhook trigger
          • Insert a row
          • Get rows
          • Update a row
        • Trouble Shootings
      • Firebase Realtime Database
        • Connection
        • Actions
          • Insert a document
          • Get documents
          • Update a document
          • Delete a document
      • Google Sheets
        • Connection
        • Actions
          • Insert a row
          • Get rows
          • Delete a row
      • SQL Server (MS-SQL)
        • Connection
        • Actions
          • Query
        • Trouble Shootings
      • MariaDB
        • Connection
        • Actions
          • Query
        • Trouble Shootings
      • Amazon Redshift
        • Connection
        • Actions
          • Query Execution
          • Get Query Status
          • Get Query Results
        • Trouble Shootings
      • Oracle Database
        • Connection
        • Actions
          • Query
        • Trouble Shootings
      • Redash
        • Connection
        • Actions
          • Create a query
          • Update a query
          • Delete a query
          • Get query result
          • Create a query job
          • Get a job result
          • Get query result by query result ID
        • Trouble Shootings
      • Microsoft Office365 Excel
        • Connection
        • Actions
          • Get rows
        • Trouble Shootings
      • CockroachDB
        • Connection
        • Actions
          • Query
        • Trouble Shootings
      • Redis
        • Connection
        • Actions
          • Get all keys
          • Get value by key
          • Search a key
          • Save the key
          • Save the key with set expiration
          • Append
          • Get exists key result
          • Get expiration count of key
          • Decrease the value
          • Increase the value
          • Delete a key
          • Flush all
    • Mail
      • SendGrid
        • Connection
        • Actions
          • Sends an Email
      • Amazon SES (Simple Email Service)
        • Connection
        • Actions
          • Sends an Email
        • Trouble Shootings
      • Gmail
        • Connection
        • Actions
          • Sends an Email
      • Stibee
        • Connection
        • Actions
          • Send Email by Trigger
          • Add a Subscriber
          • Remove a Subscriber
          • Unsubscribe a Subscriber
          • Assign the Subscriber to a Group
          • Release the Subscriber from a Group
      • Mailchimp
        • Connection
        • Actions
          • Campaign Delivery
          • Adds or Updates a Subscriber
          • Deletes a Subscriber
      • Mandrill (Mailchimp Transactional)
        • Connection
        • Actions
          • Sends an Email
          • Template Delivery
      • Mailgun
        • Connection
        • Actions
          • Sends an Email
      • Microsoft Office365 Outlook
        • Connection
        • Actions
          • Retrieves Messages from Mailfolder
          • Sends an Email
    • Message
      • Slack
        • Connection
        • Actions
          • Send a Message to Channel
          • Send a Direct Message to User
      • Microsoft Teams
        • Connection
        • Actions
          • Post a Message
      • Jandi
        • Connection
        • Actions
          • Send a Message
      • Twilio
        • Connection
        • Actions
          • Sends a SMS
      • OneSignal
        • Connection
        • Actions
          • Send message by segment
      • Solapi
        • Connection
        • Actions
          • Sends a SMS
          • Sends a LMS
          • Sends a MMS
          • Sends a Kakao Alimtalk
          • Sends a Kakao FriendTalk
          • Sends a Kakao FriendTalk (Button Type)
          • Retrieve Sending History
          • Retrieve Blacklist
        • Trouble Shootings
      • Lark
        • Connection
        • Actions
          • Send a text message via Custom Bot
          • Send a interactive message via Custom Bot
      • Discord
        • Connection
        • Actions
          • Guild (Server)
            • Get Bot Guilds
            • Get Guild Channels
            • List Guild Members
            • Search Guild Members
            • Get Guild Roles
            • Add Guild Member Role
            • Remove Guild Member Role
            • Get Guild Bans
            • Create Guild Ban
            • Remove Guild Ban
          • Message
            • Create Channel Message
            • Create Direct Message
          • Guild Scheduled Event
            • List Scheduled Events for Guild
            • Create Guild Scheduled Event
            • Get Guild Scheduled Event Users
    • Productivity
      • Google Calendar
        • Connection
        • Actions
          • Get Events
          • Insert a Event
      • Naver Open API
        • Connection
        • Actions
          • Retrieves News
          • Retrieves Trend Index
          • Retrieves Blog Posts
      • Typeform
        • Connection
        • Actions
          • Webhook Trigger
          • Retrieve Responses
      • Calendly
        • Connection
        • Actions
          • Webhook Trigger
          • Create a Single Link
      • Octoparse
        • Connection
        • Actions
          • Get Data by Offset
      • Microsoft Excel (.xlsx File)
        • Connection
        • Actions
          • Get Rows
      • Naver works
        • Connection
        • Actions
          • Retrieves Mails
          • Sends Email
          • Send a Message To Channel
          • Send a Direct Message To User
      • Notion
        • Connection
        • Actions
          • Retrieves Rows
          • Retrieves Rows with Filter
          • Create a Row
          • Update a Row
      • Korea Data API Center
        • Connection
        • Actions
          • FSC API
          • Others API
      • Microsoft OneDrive
        • Connection
        • Actions
          • Retrieves Files
      • Jira Cloud
        • Connection
        • Actions
          • Get Issues by Project
          • Get Issues by Board
          • Get Issues by Sprint
          • Create Issue
          • Create Issue Comment
          • Edit Issue
          • Delete Issue
      • Webflow
        • Connection
        • Actions
          • Get Form Responses
      • Modusign
        • Connection
        • Actions
          • Get Documents
          • Get Templates
          • Request Sign Using a Template
          • Request Send a Reminder
          • Cancel a Sign Request
          • Change Signing Due
        • Trouble Shootings
      • Google Analytics 4
        • Connection
        • Actions
          • Run Report
          • Realtime Report
      • Google Tasks
        • Connection
        • Actions
          • Get Tasklists
          • Create a Tasklist
          • Update a Tasklist
          • Delete a Tasklist
          • Get Tasks
          • Create a Task
      • Google Forms
        • Connection
        • Actions
          • Get Form Responses
      • Microsoft To Do
        • Connection
        • Actions
          • Tasklist
            • Create a Tasklist
            • Get Tasklists
            • Update a Tasklist
            • Delete a Tasklist
          • Task
            • Get Tasks
            • Create a Task
            • Update a Task
            • Delete a Task
          • Checklist
            • Get Checklist
            • Create a Checklist Item
            • Update a Checklist Item
            • Delete a Checklist Item
      • RSS
        • Connection
        • Actions
          • Get RSS Feed
    • SNS
      • LinkedIn
        • Connection
        • Actions
          • Post a Text Article
          • Post a Share Article
    • Advertisement
      • Meta(Facebook) Business Center
        • Connection
        • Actions
          • Get Leads
          • Ad Account Insights
          • Campaign Insights
          • Adset Insights
          • Ad Insights
        • Trouble Shootings
      • NAVER Search Ads
        • Connection
        • Actions
          • Campaign Stats
          • Adgroup Stats
          • Keyword Stats
          • Criterion Stats
      • Kakao Keyword Ads
        • Connection
        • Actions
          • View report on ad accounts
          • View reports on campaigns
          • View reports on ad groups
          • View reports on keywords
          • View reports on creatives
        • Trouble Shootings
      • Kakao Moment
        • Connection
        • Actions
          • View report on ad account
          • View reports on campaigns
          • View reports on ad groups
          • View reports on creatives
        • Trouble Shootings
      • Google Ads
        • Connection
        • Actions
          • Campaign Insights
          • Ad Group Insights
          • Ad Group Ad Insights
          • GAQL Execution
    • ERP
      • ECOUNT ERP
        • Connection
        • Actions
          • New Customer/Vendor
          • New Item
          • New Purchase
          • New Quotation
          • New Sales
          • New Sales Order
          • Invoice II Auto Journal (Sales)
          • Invoice II Auto Journal (Purchase)
      • Pipedrive CRM
        • Connection
        • Actions
          • Activity
            • Get all activities assigned to a particular user
            • Add an activity
            • Delete an activity
          • Deals
            • Get all deals
            • List participants of a deal
            • List products attached to a deal
            • Add a deal
            • Duplicate deal
            • Add a participant to a deal
            • Add a Product To a Deal
            • Update a deal
            • Delete a deal
            • Delete a participant from a deal
            • Delete an attached product from a deal
          • Leads
            • Get all leads
            • Add a lead
            • Update a lead
          • Organizations
            • Get all organizations
            • Add an organization
            • Delete an organization
            • List mail messages associated with an organization
            • List followers of an organization
          • Persons
            • Get all persons
            • List products associated with a person
            • Add a person
            • Delete a person
          • Products
            • Get all products
            • Get deals where a product is attached to
            • List followers of a product
            • Add a product
            • Update a product
            • Delete a product
    • Commerce
      • Woo Commerce
        • Connection
        • Actions
          • Create a Coupon
          • List All Coupons
          • Update a Coupon
          • Delete a Coupon
          • Create a Customer
          • List All Customers
          • Update a Customer
          • Delete an User
          • List All Orders
          • Create a Product
          • List All Products
          • Update a Product
          • Duplicate Product
          • Delete a Product
          • Retrieve Sales Report
      • Imweb
        • Connection
        • Actions
          • Get All Coupons
          • Get All Inquires
          • Post a Inquiry Answer
          • Get All User
          • Get All Orders
          • Get All Products
          • Get All Reviews
    • AI
      • OpenAI API (ChatGPT)
        • Connection
        • Actions
          • Chat
            • Create Chat Completion
            • Get Chat Completion
            • Get Chat Messages
            • Get List Chat Completions
            • Update a Chat Completion
            • Delete a Chat Completion
          • Embedding
            • Create Embeddings
          • Moderation
            • Create Moderation
      • Anthropic (Claude)
        • Connection
        • Actions
          • Messages
          • Count Message Token
      • Google Gemini
        • Connection
        • Actions
          • Text Generation
          • Text Generation (Extended)
          • Counting Tokens
          • Embeddings
      • Perplexity
        • Connection
        • Actions
          • Chat Completions
      • xAI (Grok)
        • Connection
        • Actions
          • Chat completions
          • Get deferred chat completions
          • Tokenize text
  • Automation
    • Getting Start
    • Tips
      • Reference value assignment
      • How to use references
    • Running the app
      • Manual Execution Button
      • Schedule
    • Add Filters
      • Text, URL Filter
      • Number, Percentage, Currency Filter
      • Datetime Filter
    • Transform Type (Optional)
      • Text
      • Number
      • Percentage
      • Datetime
      • Currency
      • URL
  • Dataflow
    • Getting Start
    • Quickstart Guide
    • Reference value assignment
    • How to use
      • Manual Execution
      • Schedule
      • Webhook
  • Settings
    • Organization & Team
    • Run Count & Run History
    • Schedule Management
  • FAQ & Policy
    • Email Change Request
    • Pricing & Subscription Cancellation
    • Roles & Management
    • Secure Policies
      • Access Controls
      • Privacy Policy
      • Security Methods
Powered by GitBook
On this page
  • Utilizing Tests and Auto-Input
  • Value Types Explanation
  • Object Type
  • Array Type
  • Returning Values as Arrays for Multiple Apps
  • Using JavaScript

Was this helpful?

  1. Dataflow

Reference value assignment

Last updated 16 days ago

Was this helpful?

Reference values are the response data generated as results when running a test. This data can be used like a variable in the next app in the way the user desires.

Utilizing Tests and Auto-Input

To view the execution results for each task or use auto-input, be sure to run 'Test with 1 data'!

  1. When you click the 'Test with 1 data' button on the right side of the Dataflow design window, it executes a single piece of data (or record).

  2. After running the test and clicking on an input field, the auto-input feature appears as shown below.


Value Types Explanation

Depending on the execution results of each task, the variable value setting type may differ based on whether it is an array or not. The following is an explanation for advanced users.

Object Type

Example Data:

{
    id: 100,
    name: "Roy",
    groupName: "Outcode"
}

Reference Example:

Hello {{a.name}}, Welcome to '{{a.groupName}}'!

Result:

Hello Roy, Welcome to 'Outcode'! 

Array Type

If the variable value is an array, you can directly use the objects inside the array.

When you enter a key from the object within the array as the result, it will automatically iterate through the array and utilize each value.

If you use an array-type result as input for another app, the app will automatically execute repeatedly once for each item in the array.

Only one-dimensional arrays are supported. Nested arrays are not supported. A nested array refers to a case where an array contains another array inside it.

Example Datas:

[
    {
        id: 100,
        name: "Roy",
        groupName: "Outcode"
    },
    {
        id: 101,
        name: "Chris",
        groupName: "Nocode"
    },
    {
        id: 102,
        name: "Soo",
        groupName: "Platform"
    }
]

Reference Example:

Hi {{a.name}}, You're invited to a '{{a.groupName}}'!

Result:

> Hi Roy, You're invited to a 'Outcode'!
> Hi Chris, You're invited to a 'Nocode'!
> Hi Soo, You're invited to a 'Platform'!

Returning Values as Arrays for Multiple Apps

When referencing arrays from multiple apps, the execution is limited to the length of the shorter array.

Example A:

[
    {
        id: 100,
        name: "Roy",
        groupName: "Outcode"
    },
    {
        id: 101,
        name: "Chris",
        groupName: "Nocode"
    },
    {
        id: 102,
        name: "Soo",
        groupName: "Platform"
    }
]

Example B:

[
    {
        id: 200,
        product: "Coke",
        price: 0.5
    },
    {
        id: 201,
        name: "Hotdog",
        groupName: 10
    }
]

Reference Example:

{{a.name}} bought a {{b.product}} for ${{b.price}}.

Result:

Roy bought a coke for $0.5.
Chris bought a coke for $0.5.

Using JavaScript

Each task returns the original data from the App as-is. However, situations may arise where the task data needs to be transformed to properly handle the data flow. For such cases, we provide a JavaScript task that allows you to transform the data and reference the transformed result.

Example A:

{
    id: 100,
    name: "Roy",
    groupName: "Outcode"
}

Example of usage in JavaScript:

return a.name;

Result:

Roy

When using a reference value that is an array in JavaScript, the entire array is passed. This allows you to either aggregate the contents of the array or access each index individually.

Example B:

[
    {
        id: 100,
        name: "Roy",
        groupName: "Outcode"
    },
    {
        id: 101,
        name: "Chris",
        groupName: "Nocode"
    },
    {
        id: 102,
        name: "Soo",
        groupName: "Platform"
    }
]

Example of usage in JavaScript:

return b[0].groupName;

Result:

Outcode