Change input parameters in API call

karim-boutmene

Hi,

I want to invoke a (Salesforce) API from an ION Data Flow, but want to make a small change to the input parameters before calling the API.

I have first registered the API in the API Gateway. It was tested and it works.

The problem is that the input parameters of the API expect a datetimeformat without the miliseconds like: 2023-05-18T16:10:00Z.

The Infor datetime format includes the milliseconds ie 2023-05-18T16:10:00.000Z. I need to remove these before the API is called. I want to use the variable [current_datetime_iso], but that includes the milliseconds, but Salesforce expects datetimes without milliseconds.

 

I had tried to do this in a Script, which seems to be able to manipulate variables. The script need to be put before the API call, but the API call is the first step in the flow. The first step can however not be a Scripting step.

How can I achieve this? Any help will be highly appreciated!

regards

Dave

Kevin Heiman

Is there a Salesforce API call to check its' status or something benign you can call.   

Or the first call could be the API call to ION scripting to run your transform and get the script output for your API call.   You could create a genric script such as strip_milliseconds_from_time 

• POST?/v1?/scripts?/{name}?/execute    Execute a script

python code...

import time

import datetime

print( datetime.datetime.utcnow())  # 2023-05-19 19:56:58.593526

datetime_value = datetime.datetime.utcnow().strftime('%Y-%m-%dT%H:%M:%S.%f')[:-7] + 'Z'

print(datetime_value)    # 2023-05-19T19:56:58Z