SK SKYVVA Documentation

How to use execute outbound interface group ?

Learning Objectives

Introduction

What is an interface group? An interface group is a unit to groups logical interfaces together. For example, you can group interfaces that are related to each other e.g. Account and Contact into one interface group. The interface group is the object the user defines at configuration time.

Interface Execution Scheduler?

This scheduler is only used with the outbound interface and is generated automatically for any outbound interface inside an integration. It uses the SOQL in the field “SOQL Query for filter sObject”. In this field, the user can write the SOQL statement which filters sObject to be passed on the method invokeCallout2(). The scheduler uses the method invokeCallout2() to execute the outbound interface. If the SOQL is not powerful enough to solve the requirement of a customer then they can use apex class to write their own logic for data selection. Then the flag “Use Apex Class” has to be set and in the field “Apex Class for Filter sObject” an apex class has to be specified. Step 1: We have to create the following data for inbound processing:

Step 2: Do mapping and save it.

Step 3: Select the interface and select the manual process as shown in Fig.

Step 4: Select the execute option and select send button.

Create Outbound Interface:-

SELECT Id,BillingCity,BillingCountry,Name,SAP_Sales_Org__c FROM Account.

Check Result on Message Monitoring :

Step 6:

Select the interface group and manually process it.

Check on message monitoring.

Run the scheduler:-

How to Execute Outbound Interface?

SKYVVA application support for outbound interface execution scheduling and manual processing with parameter expressions based on the last run date or creation date.

SKYVVA application allows users to schedule outbound interface executions based on specified time intervals (e.g., hourly, daily, weekly) or custom schedules.

Manual processing involves allowing users to trigger interface executions manually when needed as per the business requirement.

Parameter expressions dynamically pass values to the outbound interface based on certain conditions.

To utilize the last run date, the user stores this information in the configuration file and retrieves it as needed to calculate the date range for the interface.

Description: We have added two parameter expressions such as  {!_SKYVVA__RecordCreationDate} and {!_SKYVVA__RecordModificationDate}. The {!_SKYVVA__RecordCreationDate} is used for the latest records creation datetime. {!_SKYVVA__RecordModificationDate} is used for the latest records modification datetime. It will check the last records changed to be sent by the InterfaceExecution scheduler. For example, SOQL as SELECT Id FROM Account WHERE LastModifiedDate > {!_SKYVVA__RecordModificationDate}.

Two parameter expressions in the system: {!_SKYVVA__RecordCreationDate} and {!_SKYVVA__RecordModificationDate}. These expressions are used to capture and reference date and time information related to records in the system. Here's a breakdown of how these parameter expressions are being used:

This expression is used to capture the datetime of the latest record creation in the SKYVVA application.

This expression is used to capture the datetime of the latest record modification in your SKYVVA application.

How to Execute Outbound Interface By Scheduler?

Business Scenario: Test with 1000 records to send data out by InterfaceExecute.

To perform a test with 1000 records to send data out using InterfaceExecute. Here's a general outline of steps the user has to follow for testing with 1000 records:

[su_box title="Expectation: " box_color="#2a8af0" title_color="#000000"]When the InterfaceExecute scheduler runs, it will take 1000 records with NewCreateDate or LastModifyDate to send data out. [/su_box] The scheduler "InterfaceExecute" that the user wants to run. The user expectation is that when this scheduler runs, it should process or take 1000 records based on either "NewCreateDate" or "LastModifyDate" and send that data out.

Here's a breakdown of what this expectation means:

Required step:

{!_SKYVVA__RecordCreationDate}: use for latest records creation date time

{!_SKYVVA__RecordModificationDate}: use for latest records modification time

Message Monitoring

[su_box title="Result:" box_color="#2a8af0" title_color="#000000"]After the InterfaceExecute scheduler run is completed, it will take 1000 records with NewCreateDate or the LastModifyDate to send data out.[/su_box]

A scheduler and record selection criteria based on either the "NewCreateDate" or the "LastModifyDate" fields. After the "InterfaceExecute" scheduler run is completed, the process will select 1000 records that meet the specified criteria to send data out.

Here's a breakdown of the key components:

[su_box title="Note" box_color="#33FF77" title_color="#000000"]If there is no record new or update then nothing to do for the scheduler.[/su_box]

How to Execute Outbound Interface By Manual Process?

The business scenario where an integrated SKYVVA application. The user experienced a record update due to a manual process. This is a common practice for data updates.

Here's a breakdown of the information you provided:

[su_box title="Expectation:" box_color="#2a8af0" title_color="#000000"]We use the manual process to transfer records that have the latest updated[/su_box]

Message Monitoring

The results related to transferring records based on their LastModifiedDate field. Data processing means that the user has to send out data that has been updated most recently.

Here's a breakdown of the statement:

[su_box title="Result:" box_color="#2a8af0" title_color="#000000"]It will transfer records that have the latest updated (LastModifiedDate) to send data out.[/su_box]

Open this article in the interactive viewer →