Integration

Get Involved. Join the Conversation.

Topic

    Karthick R
    FTP Adapter - Master Detail CSV File - Unable to IDENTIFY...
    Topic posted November 10, 2019 by Karthick RRed Ribbon: 250+ Points, tagged Adapters, Integration, Mapping, Orchestration, SOAP, Web Services 
    16 Views, 6 Comments
    Title:
    FTP Adapter - Master Detail CSV File - Unable to IDENTIFY master detail information
    Summary:
    FTP Adapter - Master Detail CSV File - Unable to IDENTIFY master detail information
    Content:

    Hi Everyone,

    Scenario- CSV placed in FTP location in the below format. This CSV is supposed to be a Master Detail file.
    Now, How can we infer whether it's a header or line information from CSV file?
    I was looking for options in the OIC read file schema section. But found nothing.
    There weren't sub elements available.

    Reason for Identification - After processing the file I have to invoke Fusion AR - Invoice creation web service which expects header and line information.

    Header fields:
    1. Business Unit
    2. Transaction Source
    3. Transaction Type
    4. Transaction Number
    5. Transaction Date

    Line Fields:
    1. Line Number
    2. Description
    3. Quantity
    4. Unit Price

    Sample CSV Data File Format:
    BUSINESS UNIT,TRANSACTION SOURCE,TRANSACTION TYPE,TRANSACTION NUMBER,TRANSACTION DATE,LINE NUMBER,DESCRIPTION,QUANTITY,UNIT PRICE
    BU1, INVOICE, CREDIT_INVOICE,12345, 2019-11-10,1, Line1,10,5
    , , , , 2019-11-10,2, Line2,20,10
    , , , , 2019-11-10,3, Line3,30,15
    BU2, INVOICE, CREDIT_INVOICE,67890, 2019-11-10,1, Line1a,40,20
    , , , , 2019-11-10,2, Line2a,50,25
    , , , , 2019-11-10,3, Line3a,60,30

    Regards,
    Karthick.R

    Comment

     

    • Ankur Jain

      Hi Karthick,

      Would you want to create to two separate files from source file one for header information and second for line item information ?

      Regards,

      Ankur

      • Karthick R

        Hi Ankur,

        No.

        We need to invoke Fusion AR - createSimpleInvoice at once by passing Header and Line information.

        Please refer the screenshot in another comment below.

        Regards,

        Karthick.R

    • Hemanth Lakkaraju

      First four fields are empty - would that not give a hint that these are "detail" records?

      • Karthick R

        Hi Hemanth,

        Yes. Certainly.

        The problem is I'm looking for sub elements for passing line information to web service.

        Fusion AR - createSimpleInvoice web service method expects a header element and zero or more line elements.

        In the above csv, each invoice record has 3 lines.

        How will I map these 3 lines for each header in web service?

        Regards,

        Karthick.R

        • Hemanth Lakkaraju

          Your expectation is incorrect. The recordset cannot hold master child data. You just need to handle that in your XSLT using custom templates (and upload xslt probably).

          • Karthick R

            Hi Hemanth,

            Can you please share any blog/reference material on (how to handle XSLT using custom templates (and upload xslt probably)).

            Regards,

            Karthick.R