Skip to main content

XML

Prophecy Automate

Read or write an XML file from an external connection.

info

You can also use the upload file feature to use XML files. These will be stored in the SQL warehouse configured in your fabric.

Supported connections

Parameters

ParameterTabDescription
Connection typeTypeLocation you want to connect from.
Format typeSource locationFormat of the gem. In this case, xml.
Select or create connectionSource locationWhether to select an existing connection, or to create a new one.
FilepathSource locationFile path where you want to read and write files according to the connection type.
PropertiesPropertiesOptional table properties to apply. Source are outlined below.
SchemaPropertiesSchema definition of the table (custom or inferred).

Source properties

PropertyDescriptionDefault
DescriptionDescription of the table.None
Row TagXML tag that identifies a single row or record in the dataset.None
Inference Data Sampling LimitMaximum number of rows to sample for inferring the schema.0