Spike - look into technical requirements + implementation approaches for SFTPing data files to BCMail+ and BC Laws

[argush3]

Not sure if we need to SFTP XML files to BC Laws. Argus & Dylan will talk to BC Laws to confirm. If it turns out that we do not transmit to BC Laws using SFTP, we will cut another ticket to figure out how to transmit.

We need to do some investigation to get some questioned answered around the SFTP requirements for BCMail+ and BC Laws.

The desired outcome is that we have enough information to start implementing the upload of data files to BCMail+ and BC Laws via SFTP.

Some questions that need to be answered:

• Do we have staging areas we can use to test BCMail+ pdf uploads? If so, are we able to get credentials and other required info like folder name and etc
• Do we have staging areas we can use to test BCLaws XML file uploads? If so, are we able to get credentials and other required info like folder name and etc
• Can we leverage the SFTP code that PPR has used for SFTPing to BCMail+?
  • ppr/services/document-delivery-service/src/document_delivery_service/services/sftp.py at ece1c430111043be4f43b5f1f9c013744827c504 · bcgov/ppr
  • ppr/services/document-delivery-service/src/document_delivery_service/service.py at 7510ec7e1c2500150b9145dbd51ee01ce759834e · bcgov/ppr
  • ppr/services/document-delivery-service/src/document_delivery_service/services/documents.py at ece1c430111043be4f43b5f1f9c013744827c504 · bcgov/ppr

TODOs

• Analyze what we need to figure out in order to start implementing upload data files to BCMail+ and BC Laws
• Answer questions in description as well as any other questions that come out of analysis
• Potentially test SFTP credentials received manually against staging SFTP servers if possible
• Create required tickets to SFTP data files for BCMail+ and BCLaws flows as required