Hi Team,
I have an SQL query to fetch the records from DB and then am doing further filtration to validate the records.
Below is the select statement and based on the records, I need to check whether Email id is valid against the domains maintain...
Hi Team,
I am querying a DB and I want to write two csv files in parallel.
1. All the valid records as in skipping null/blank values, valid email id - File 1.csv
2. All invalid records as in null/blank records, invalid email id - file 2.csv
I...
Hi Team,
I have a below requirement.
Interface will execute weekly once where I query a DB and pull the records and write a csv file.
1. I want to store the last week file in a location and compare it with current week run file.
2. Based on U...
Hi Team,
For exception handling, I have created another common iflow which is being called using ProcessDirect adapter.
Original Iflow exception subprocess:
Iflow to trigger Email:
When I trigger mail, How to get below properties of the...
Hi Team,
I have a header parameter as QAuthorization which has the token value. I want to log it as an attachment. How to do it using is groovy script in CPI ?
Thanks,
Varun
Hi Sri,Thanks alot for the response and apologies for the late reply. I am able to achieve above requirement as you suggested.I have a doubt related to "externalizing parameters"In the content modifier step, I am passing constant as below under "Mess...
Hi Team,Thanks for sharing the details around odata.I am working on an interface in SAP PO 7.5 odata v2 adapter where trying to query data from a thirdparty application. In the metadata, I have the fields CREATED_AT and MODIFIED_AT in the format "YYY...
Hi Team,I did the required XST code and is working standalone when I test in Sylus studio, but when I import the mapping in PO and run it, I am facing below issue with test function. I tried with choose or If functions, both are failing."Required att...