Uploading Files to an SFTP Server

To upload a file to an SFTP server:

  1. Add a new URL object.

    1. Select PeopleTools, and then Utilities, and then Administration, and then Maintain URLs.

      The URL Maintenance page appears.

    2. Add the following values:

      Field Value

      URL Identifier

      SFTPTESTURL

      Description

      SFTP Server URL

      URLID

      Enter the appropriate URL. For example:

      sftp://<userid>:<password>@<address>:<port>
    3. Save the changes.

  2. In PeopleSoft Application Designer, open the EXAMPLE_WORKREC record and add the following PeopleCode to the FieldChange event for the TEST field:

    Local array of Message &messages;
    Local array of Message &responses;
    Local Message &MSG;
    Local array of string &nodenames;
    Local string &node;
    
    &xmldata = "<?xml version='1.0'?><sftpTest/>";
    
    &xmlDoc = CreateXmlDoc(&xmldata);
    
    &rootNode = &xmlDoc.documentelement;
    &descNode = &rootNode.AddElement("Payload");
    &descNode.NodeValue = "Generated at " | %Datetime;
    &messages = CreateArrayRept(&MSG, 0);
    &nodenames = CreateArrayRept(&node, 0);
    
    &nodenames [1] = "TARGETNODE";
    &messages [1] = CreateMessage(Operation.EXAMPLE_SERVICE_OPR);
    &messages [1].SetXmlDoc(&xmlDoc);
    
    &responses = %IntBroker.SyncRequest(&messages, &nodenames);
    
  3. In the PeopleSoft Pure Internet Architecture, open the TARGETNODE node definition and do the following:

    1. On the Node Definitions-Connectors tab, set the Connector ID to SFTPTARGET.

    2. Set the following properties to the values indicated:

      Property Value

      BASE64ENCODE

      Y.

      CHARSET

      UTF-8.

      METHOD

      PUT.

      REMOTEFILENAME

      SFTPTestFile.txt.

      URL

      SFTPTESTURL.

  4. In the PeopleSoft Pure Internet Architecture, open the EXAMPLE_PAGE page and click the Test button.

    Login to the SFTP server and check for the file. Open the SFTPTestFile.txt file and verify the contents.