SAP Knowledge Base Article - Public

2453500 - How to Export Notes Using Data Workbench

Symptom

How to export the Notes for Data Workbench Objects like Accounts, Contacts, Opportunities and so on using Data Workbench.

Resolution

To export the notes you can follow the below steps

  1. Go to Data Workbench work center
  2. Select Export View
  3. Select Account Notes / Contact Notes object
  4. Select All Data or Select the Account for which you want note to be extracted
  5. Select Next
  6. Select Export Data

Also as a workaround, you may extract the Notes for the objects like Accounts, Contacts, using the below steps.

  1. Go to Administrator work center
  2. Go to OData Service Explorer view
  3. Show SAP Odata Services
  4. Highlight the Service name: c4codataap1 and select Test
  5. On the OData Console, in the left pane, select the Entity Set (for Example: AccountNotesCollection)
  6. Select the Test tab
  7. Copy the URL available in the Request Method GET
  8. Run the the query https://myxxxxxx.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/CorporateAccountCollection in Chrome browser
  9. Select the Object ID for any Account, which is obtained from the execution of the above URL (for example: 00163XXXXXXXXXXXXXXXXXXXXXXXXXXX)
  10. Now query https://myxxxxxx.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/AccountCollection('<ObjectID>')/CorporateAccountTextCollection
  11. You will be able to see the Account Notes maintained for the Account
  12. Similarly, for Contacts we have the Entity Set ContactNotesCollection
  13. The query is https://myxxxxxx.crm.ondemand.com/sap/c4c/odata/v1/c4codata/ContactCollection
  14. Select the Object ID for any Contact, which is obtained from the execution of the above URL (for example: 00163YYYYYYYYYYYYYYYYYYYYYYYYYYY)
  15. Now query https://myxxxxxx.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/ContactCollection('<ObjectID>')/ContactTextCollection

Keywords

Data Workbench, Export Notes using Data Workbench , KBA , data workbench , export notes using data workbench , LOD-CRM-INT-DWB , Data Workbench , How To

Product

SAP Cloud for Customer 1805 ; SAP Cloud for Customer add-ins 1802 ; SAP Cloud for Customer add-ins 1808 ; SAP Cloud for Customer add-ins 1811 ; SAP Cloud for Customer add-ins 1902 ; SAP Hybris Cloud for Customer add-ins 1711