List of Contributions

RICHARD CROSS

Contact Details

My Content

1 to 13 of 13 total
Posted By RICHARD CROSS Apr 22, 2020 8:00 AM
Found In Egroup: B2B Integration
\ view thread
Hi Rags, I know of a customer here in the UK running SI (SFG) and SSP on AWS EC2, although not yet ICC. Their SI instance uses RDS (Oracle) for the database without any problem so I would expect the same to be true of ICC. Best regards, Richard. ------------------------------ RICHARD CROSS --------- ...
Posted By RICHARD CROSS Mar 31, 2020 5:38 AM
Found In Egroup: B2B Integration
\ view thread
Hi Paul, I could do with that! :-) Have you tried using the Excel adapter now available in ITX to write the data directly as an XLS instead of a CSV? I've only gone the other way as Rex Chan helped me put together a map to read an XLS and convert it to JSON for a use case a UK financial institution had. ...
Posted By RICHARD CROSS Jan 6, 2020 5:01 AM
Found In Egroup: B2B Integration
\ view thread
Hi David, Eventually you'll have the option of using REST APIs for that but not all the ones you'd need are there yet. Meanwhile the tried and trusted method of export and import is the way to go. Export the configs to a file, and then import that file into Prod. There's a section in the docs on this: ...
Posted By RICHARD CROSS Nov 27, 2019 1:50 PM
Found In Egroup: B2B Integration
\ view thread
You need to provide the parameters to the SFTP Client Begin Session service to tell it how to connect to the SFTP Server. RemoteHost is the IP address or DNS of the SFTP Server you want to connect to. You can either specify it directly or it could be got from the SSH Remote Profile (set these up through ...
Posted By RICHARD CROSS Nov 19, 2019 11:27 AM
Found In Egroup: B2B Integration
\ view thread
In v6 for each REST call just build the parameters using Assign into an area of ProcessData, then use the XML JSON Transform service ( https://www.ibm.com/support/knowledgecenter/en/SS3JSW_6.0.1/integrating/integrating/integrator/XML-JSON_service.html ) to convert to JSON and pass it to the REST Client ...
Posted By RICHARD CROSS Nov 19, 2019 10:36 AM
Found In Egroup: B2B Integration
\ view thread
This will be easier with SFG v6 as you can use the REST API Client for all calls except the document get plus you have the JSON Transform service to convert between the JSON input/output and ProcessData XML. The challenge with the document get is that you need to save the Logon and Token keys from the ...
Posted By RICHARD CROSS Nov 19, 2019 9:38 AM
Found In Egroup: B2B Integration
\ view thread
Hi Len, Depends what's available from USPS. Do you mean retrieve the file via a REST call to USPS? If so then you'd need to use the HTTP Client adapters to connect to and issue the relevant HTTP calls to get the file from USPS's REST server. The Client GET (or POST) service will store the response as ...
Posted By RICHARD CROSS Nov 19, 2019 8:21 AM
Found In Egroup: B2B Integration
\ view thread
Hi Len, I believe you can use the export/import utilities to export a code list from one environment and then import to another. REST APIs including code list APIs have been available since 5.2.6.1 but each new version introduces more for example v6.0.2 brought in myFileGateway 2.0 which required adding ...
Posted By RICHARD CROSS Nov 13, 2019 6:19 AM
Found In Egroup: B2B Integration
\ view thread
Hi Len, To convert ABC.CYC123.xyz to DAILY.CHECKS.CYC123 you need to do something like this: - Define your producer file structure regular expression as (.+)/.(.+)/.(.+) and under facts specify myFilePrefix, myFilePart,myFileSuffix; each section in brackets () is extracted and stored as a "fact" which ...
Posted By RICHARD CROSS Jun 7, 2019 4:48 AM
Found In Egroup: B2B Integration
\ view thread
Hi Mohammed, Check your setup.cfg (see https://www.ibm.com/support/knowledgecenter/en/SS3JSW_6.0.0/installing/installing/integrator/SI_Creating_setupcfg.html). What value do you have assigned to SOFT_STOP_TIMEOUT= ? It is optional so you can leave it out completely but if it's in there (like in the sample ...
Posted By RICHARD CROSS Jun 6, 2019 10:24 AM
Found In Egroup: B2B Integration
\ view thread
Hi Derrick, Glad to hear you got it working. Would you be able to share any more of the BP around how you setup the session with SharePoint and what headers you're setting? Thanks, Richard. ------------------------------ RICHARD CROSS ------------------------------
Posted By RICHARD CROSS May 31, 2019 12:04 PM
Found In Egroup: B2B Integration
\ view thread
Hi Derrick, I've seen similar when doing an HTTP GET. Every time it's because I've forgotten that a "feature" of B2Bi is that if you have a PrimaryDocument it will append it like POST data to the HTTP GET request, which of course is not supported. What you should do is Assign PrimaryDocument to another ...
Posted By RICHARD CROSS Oct 9, 2018 4:13 AM
Found In Egroup: File Transfer
\ view thread
Hi Lisa, You can use the Timestamp Utility service: https://www.ibm.com/support/knowledgecenter/en/SS3JSW_6.0.0/integrating/integrating/integrator/Timestamp_Utility_svc.html For example use the Timestamp Current Time function to get the current month e.g. set format to yyyyMM, then use the XPATH concat() ...