FBDI
Summary
FBDI dataContent
Hello - we have a data coming from a financial firm that we need to import in Fusion App General Ledger Journal entry. So we are using FTP adapter, OIC and ERP adapter. Now the data we receive from this firm is a RESt response XML/Json response.
Question : we know ERP Import job will accept data in FBDI format ( meaning .csv only ) . If we were to run import Journal job on ERP side we know it will accept a zip file comprising of .csv file and .properties file
Now if the source is not csv then what are our options in OIC ? Does that mean after getting above REST response from vendor we have to first convert response data TO csv with in OIC before importing to ERP ? Is OIC meant / ideal for this conversion ? What else are options when vendor does not provide data in csv format ?