Use case with XML format data
Steps for the integration process for XML data format is described below
Procedure
- Use the Salesforce tools or manually create the metadata JSON file for the data to be loaded onto Analytics Cloud
- Load the JSON file into the Cast Iron project as a default value in a string variable
- Use the appropriate Cast Iron activity (HTTP, FTP, etc) to receive the XML data
- 1. Use the 'Create Dataset' activity to map the ' EdgeMartAlias ' and 'Operation'. Specify 'Format' to be 'CSV'. Base-64 encode the JSON and map to MetadataJson
- 1. Serialize the XML data using the 'Write XML' activity. Refer Example 1: How to Configure the Write XML Activity for XML Data on how to configure this activity to serialize the XML correctly
- Use the 'Load Data' activity to map the ' InsightsExternalDataId ' and ' PartNumber ' (optional). Base-64 encode the XML and map to ' DataFile '. Specify ' DataFormat ' to be 'XML'. This will configure the the connector to internally convert the XML to CSV and invoke the SFDC Analytics API with the CSV
- Use the 'Update Dataset' activity to set the processing status Refer the topic " How to configure the Write XML Activity for XML Data "
- Use the 'Retrieve Dataset' activity to poll Analytics Cloud for the status of the data load