How to archive C4C all attachment to local server

[Former Member]

Hi expect,

Is there any way I can archive C4C attachment to local server?

Please advise.

Thank

Raymond

[pushkar_ranjan · Accepted solution]

This is planned for delivery early next year via functionality available within C4C Data Workbench. Stay tuned on this community for more information. Thank you.

[Former Member · Accepted solution]

Can I retrieve it now as per instruction from my boss?

By using oData or web service?

Thanks

[Former Member · Accepted solution]

Yes. You could write a custom program in your app platform or use an ETL/data management platform of choice (such as Data Services) to call the C4C apis to get the attachment data out for archiving purposes. What Pushkar is referring to is a more "point and click" way so it is easier to eventually do this with the oData work bench.

[Former Member · Accepted solution]

what is the business object name to download the attachment?

I couldnt find any related BO name related to attachment.

Please advise.

Thanks

[Former Member · Accepted solution]

The attachment is a special object that doesnt exist as its own entity. Instead it exists as a node (1:many) stru for every business object that implements the attachment functionality. You can access the attachment node of a standard and custom object through the odata explorer, public SOAP APIs that have exposed it, and the PSM in SDK.

[Former Member · Accepted solution]

My object is to download physical file from C4C.

I am not able to find the similar function through odata. But the SOAP APIs allow me to get the attachment file info, not the physical file. From the sample below, i am not able to access the FileContentURI. I were so hope it will show me the 64bit code, but actually not.

<AttachmentFolder>

               <UUID>00163e0a-c1ad-1ed5-9ef2-b9b27dbdf293</UUID>

               <Document>

                  <UUID>00163e0a-c1ad-1ed5-9ef2-baa5ba3e1293</UUID>

                  <VersionID>0</VersionID>

                  <SystemAdministrativeData>

                     <CreationDateTime>2015-10-26T03:58:39.981747Z</CreationDateTime>

                     <CreationIdentityUUID>00163e09-3b4c-1ed4-9190-8e067e3db546</CreationIdentityUUID>

                     <LastChangeDateTime>2015-10-26T03:58:39.981747Z</LastChangeDateTime>

                     <LastChangeIdentityUUID>00163e09-3b4c-1ed4-9190-8e067e3db546</LastChangeIdentityUUID>

                  </SystemAdministrativeData>

                  <VisibleIndicator>true</VisibleIndicator>

                  <CategoryCode>2</CategoryCode>

                  <TypeCode>10001</TypeCode>

                  <MIMECode>image/jpg</MIMECode>

                  <PathName>/BOAttachments/00163E0AC1AD1ED59EF2B9B27DBDF293/happy_face.jpg</PathName>

                  <Name>happy_face.jpg</Name>

                  <AlternativeName>happy_face.jpg</AlternativeName>

                  <FileContentURI>http://vacildz.byd.sap.corp:50000/sap/ap/ds/wd/doc/00163E0AC1AD1ED59EF2BAA5BA3E1293/happy_face.jpg?s...</FileContentURI>

                  <FilesizeMeasure unitCode="AD">2355.0</FilesizeMeasure>

               </Document>

            </AttachmentFolder>

[Former Member · Accepted solution]

FWD: and

[Former Member · Accepted solution]

For which standard BO is this for?

Thanks

[prabhatraman · Accepted solution]

Hello Raymond

for example if you search for the opportunity using odata service - you will get result something like this

<link href="OpportunityCollection('00163E04B6021EE2B3C2A1CEA2FDAFE1')/OpportunityAttachment" rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/OpportunityAttachment" type="application/atom+xml;type=feed" title="OpportunityAttachment"/>

<m:properties>

<d:AccountID>10005</d:AccountID>

<d:AccountName m:type="c4codata.ENCRYPTED_LONG_Name">

<d:languageCode>E</d:languageCode>

<d:content>FutureVision</d:content>

</d:AccountName>

<d:AccountUUID>00163E03-A070-1ED2-8B9D-AF815863501D</d:AccountUUID>

<d:ApprovalStatusCode>1</d:ApprovalStatusCode>

<d:ApprovalStatusCodeText>Not Started</d:ApprovalStatusCodeText>

<d:CategoryCode/>

<d:CategoryCodeText/>

here you can find the link for attachement for a particular opportunity like shown below -

https://<c4c tenant./sap/byd/odata/v1/c4codata/OpportunityCollection('00163E04B6021EE2B3C2A1CEA2FDAFE1')/OpportunityAttachment

if you follow this link you will get attachments in base64 encoded binary.

[Former Member · Accepted solution]

If i want to archive attachment from the Registered Product??

Thanks

[Former Member · Accepted solution]

The Registered product is a special BO and consists of both the Individual Product and Installation Point BOs. and would be best to comment which of the two BOs/path you would need to explore using the oDATA explorer to access the attachment node via oDATA.

[Anshika · Accepted solution]

Hi Raymond,

For Registered Products, the Installation Point BO has the association to Attachment.

Regards,

Anshika

[Former Member · Accepted solution]

Hi Anshika,

I am still not able to get the binary string from the installation point BO. Can you please advise what else I need to set to achieve it?

Thanks

regards,

Raymond

[Former Member · Accepted solution]

FYI

[Anshika · Accepted solution]

Hi Raymond,

The attachment association is not PSM enabled and hence you cannot see it in the OData explorer.

We will enable it in the future so that it can be used in such scenarios.

Please also note a correction in the BO which has this association - For Registered Products, the Individual Product BO has the association to Attachment - this will be enabled for PSM in the future. (I mentioned installation point in my earlier post, which is not correct, sorry for that).

Regards,

Anshika

[Former Member · Accepted solution]

HI Anshika,

Thank you for the reply.

Is this same thing happen to the Email Attachment?

Thanks

Regards,

Raymond

[former_member184390 · Accepted solution]

hi Pushkar,

Just wanted to check if you have any update on Archiving functionality in C4C.

Thanks

Uday

[HorstSchaude]

Hello,

We will start with Archiving hopefully in 2021.
This will cover in the first steps the Business Objects

• Customer Quote
• Customer Order
• Task
• Ticket

More objects will follow.

HTH,
. Horst

[former_member319166]

Hello Horst,

Is the archiving functionality that you mentioned in this post already implemented?

If yes, could you tell me more or do you have any Link with more information about how that work?

Many thanks!

Alicia

[HorstSchaude]

Hello Alicia,

Yes, Archiving is implemented and general available.

Here are some links to my blogs:

https://blogs.sap.com/2020/12/03/archiving-how-it-is-designed-how-does-it-work/

https://blogs.sap.com/2020/12/18/archiving-what-objects-what-are-the-criteria/

HTH,
Horst

[former_member319166]

Vielen lieben Dank für die schnelle Antwort und einen schönen Tag

Alicia