<request type="EXPORT_VALUES" desc="Actual Export A">
<parameters>
<parameter name="APPLICATION" value="SAMPLE1"/> (1)
<parameter name="FORM" value="IMPORT_ACT1"/> (2)
<parameter name="PARTICIPANT" value="#NONE"/> (3)
<parameter name="POV" key="#FY" value="FY2015"/> (4)
<parameter name="FORMAT" value="csv"/> (5)
<parameter name="NEWLINE_STYLE" value="lf"/> (6)
<parameter name="QUOTE_STYLE" value="always"/> (7)
</parameters>
<contents> (8)
</contents>
</request>
Exporting Data Using Forms
This manual is in pilot operation.
|
Overview
This function is the same as Exporting Data performed via fusion_place [Browser]. It exports ledger data via a form in CSV format, based on specified form, data POV, and participant.
How to Write a Request
Below is an example request for "Exporting Data Using Forms":
1 | "Application" parameter |
2 | "Form" parameter |
3 | "Participant" parameter |
4 | "Data POV" parameter |
5 | "Format" parameter |
6 | "Newline Style" parameter |
7 | "Quote Style" parameter |
8 | No request content needed |
Parameters
Specify the same items as when displaying data using forms via fusion_place [Browser] (except MIN_SEVERITY
, which cannot be specified via [Browser]).
Parameter | Required | Key | Description |
---|---|---|---|
APPLICATION |
Yes |
None |
Specify the label of the target application. |
LEDGER_EDITION |
No |
None |
Specify the ledger edition key to use. If omitted, the "workspace" edition is used. Reserved keys are:
|
FORM |
Yes |
None |
Specify the label of the form used for export. |
PARTICIPANT |
Yes |
None |
Specify the label of the participant selected at export. For workgroup applications, specify |
POV |
No |
Yes |
Specify the parameter (data POV) members for the form. Set the dimension label in the All dimensions set as form parameters must be specified. |
FORMAT |
No |
None |
Specifies the format of the returned content. If omitted, Available formats:
|
NEWLINE_STYLE |
No |
None |
Specifies the newline style of the returned content. If omitted, Available newline styles:
|
QUOTE_STYLE |
No |
None |
Specifies the quoting style for the returned content. If omitted, it is treated as Available quoting styles:
|
Response Content
Below is an example response for "Exporting Data Using Forms":
<response type="EXPORT_VALUES" desc="Actual Export A">
<returned-contents>
"","FY2015 M12","FY2010 M12","Year-over-Year Diff","YoY (%)" (1)
" Revenue[PL_SAL]", "0", "3245.94", "3245.94", "#DIV/0!"
" Cost of Goods Sold[PL_COS]", "0", "2042.64", "2042.64", "#DIV/0!"
" Gross Profit[PL_GRM]", "0", "1203.3", "1203.3", "#DIV/0!"
<!-- ... -->
</returned-contents>
<result>
<code>SUCCESSFUL</code> (2)
<started-at time-zone="Asia/Tokyo">2015/02/28 09:50:04.227</started-at>
<ended-at time-zone="Asia/Tokyo">2015/02/28 09:50:07.827</ended-at>
<messages> (3)
</messages>
</result>
</response>
1 | Returned Content |
2 | Processing Result Code |
3 | Message |