OIC - Use of Translate function

Requirements: To remove the aposthrope (') from a string.

Format:

translate($variable_name,"'",'')

We can also replace one special char to another one using translate function.

S3 rest service call to get the file object using contents key name from postman

 

Step1: Provide verb and rest URL

Verb: Get

URL format: https://buketname.s3.regionname.amazonaws.com/keyname

Where keyname= file_object_path/File_object_name with extension

Step2: Choose type as AWS signature and provide the follow information:

1. access key

2. secret key

3. AWS region: us-west-2(for example)

4. Service Name: s3

Step4: Run it.

S3 rest service call to get key or object name using postman

Step1: Provide verb and rest URL

Verb: Get

URL format: https://buketname.s3.regionname.amazonaws.com/?QueryParameters

QueryParameters used:

list-type=2&prefix=filePath/&delimiter=/&query=Contents[?contains(key,' ')]

Step2: Choose type as aws signature and provide the follow information:

1. access key

2. secret key

3. AWS region: us-west-2(for example)

4. Service Name: s3

Step4: Run it.

OIC - Javascript - Replace String custom function

Usecase: If we use default replace string () function , what we observe that it does not allow to activate the integration. So we need to create a custom javascript function to replace a string with another one.

Here we will replace "_" with "/".

JS code:

function replaceString(value, str1,str2){

output = value.replace(new RegExp(str1, "g"), str2)

return output;

}

Implementation steps with screenshots:

OIC - Synchronous Integrations Occasionally Fail with a 504 Gateway Time-out Error

 Synchronous Integrations Occasionally Fail with a 504 Gateway Time-out Error

Synchronous integrations can fail with the following error.

    Bad response: 504 Gateway Time-out from url

    https://Instance_URL/Integration_Name/Version_Number/

This error occurs because synchronous integrations (integrations that return a response payload) are limited to 300 seconds and return a timeout error if they exceed that limit.

Optimize your integration and/or the endpoint you invoke to complete instance execution in under 300 seconds.

server limits:

server-Limits

OIC - JS - Return boolean status based on ERP result status

Requirement:

From ERP we are getting Import status as 'SUCCEEDED','WARNING','ERROR','CANCELED' and we need to convert it to boolean status like true or false.

JS code:

function returnStatus(result) {

 var inProgress;

  if (['SUCCEEDED','WARNING','ERROR','CANCELED'].indexOf(result)==-1)

  {

  inProgress = "true";

  }

  else

  {

  inProgress="false"

  }

  return inProgress;

}

OIC - Javascript - to remove carriage return

For instance the method you made could be made more general to parse input from several different types of files. Due to differences in Operating system it is quite common to have files with \n or \r where a new line is required. To be able to handle both your code could be rewritten using some features of regular expressions. 

function removeCarriageReturn(variable){

var newString = "";

var newString =variable.replace(/[\n\r]/g, '');

return newString;

}