topic Re: Create a CSV with 2 Header lines in Workato Pros Discussion Board

Create a CSV with 2 Header lines

ConnorSkillsoft — Mon, 22 Jan 2024 11:54:49 GMT

I'm attempting to create a CSV file with 2 header lines for an integration between D365 and Coupa:

Requisition

Submit For Approval?

Justification

Requested By (Email)

Requested By (Login)

Ship to Location Code

Hide Price

po_email_address

event__work_order

event_start_date

event_end_date

Requisition Line

Line Number

Catalog Item Number

Non Catalog Item Description

Supplier Part Number

Quantity

Price

UOM Code

Need By Date

Supplier Number

Commodity Name

Currency Code

Chart of Account Name

Account Code

Account Segment 1

Account Segment 2

Account Segment 3

Account Segment 4

Account Segment 5

Payment Term Code

asset_location

asset_tag

asset_id

service_start_date

service_end_date

product

expense_gl

profile_id

users_dept

channel

modality

product_line

activity

Re: Create a CSV with 2 Header lines

gary1 — Mon, 22 Jan 2024 17:16:20 GMT

I've never seen this kind of formatting before. Is the final CSV always only 4 lines?

Re: Create a CSV with 2 Header lines

brian-haskins — Mon, 22 Jan 2024 19:07:56 GMT

What are you trying to accomplish with the integration?

In theory, it should only be one file, one header row with many fields or two files with transformation between the two. The only example I can think of is what Concur does with their Extracts where its 235 columns across but it contains the lowest level of detail you need. The screenshot below shows the column order and different types of data including line level data.

Re: Create a CSV with 2 Header lines

ConnorSkillsoft — Tue, 23 Jan 2024 12:53:17 GMT

Me either, find it very strange. Correct only ever 4 lines.

Re: Create a CSV with 2 Header lines

ConnorSkillsoft — Tue, 23 Jan 2024 12:56:10 GMT

This is for creating requisitions within Coupa, from Purchase Order information in Dynamics 365.

Agreed, the formatting is odd. I had explored the option of generating 2 seperate CSV files (1 for each header line) and appending, but that hasn't appeared to work!

Re: Create a CSV with 2 Header lines

brian-haskins — Tue, 23 Jan 2024 15:46:47 GMT

Coupa should have example import files either with the schema or how they want it imported. Either in a portal or through Support.
https://compass.coupa.com/en-us/products/product-documentation/integration-technical-documentation/coupa-core-flat-files-(csv)/flat-file-(csv)-import/requisitions-import

Re: Create a CSV with 2 Header lines

gary1 — Tue, 23 Jan 2024 16:28:01 GMT

Got it. I would construct this one line at a time. If you're comfortable scripting, you can write a single action to make an array of arrays, and then convert the array to CSV.

Here's a quick Ruby snippet that should do the trick. You just need to flesh out the variables before pushing them into the array. Make sure each array variable has the same amount of items (even if blank) so the CSV columns remain aligned.

array = [] req_header = ["Requisition","Submit For Approval?","Justification","..."] req_line_header = ["Line Number","Catalog Item Number","Non Catalog Item Description","..."] req_line = ["Requisition","..."] req_line_line = ["Requisition Line","..."] array.push(req_header, req_line_header, req_line, req_line_line) csv = array.to_csv ## output {csv: csv}

Let me know if you need more help with this.

Re: Create a CSV with 2 Header lines

ConnorSkillsoft — Tue, 23 Jan 2024 17:18:11 GMT

Thanks so much!

Re: Create a CSV with 2 Header lines

ConnorSkillsoft — Tue, 23 Jan 2024 17:18:29 GMT

Thankyou!

Re: Create a CSV with 2 Header lines

meghan-legaspi — Thu, 25 Jan 2024 00:09:56 GMT

Hey @ConnorSkillsoft, did any of the provided responses help you resolve? Please let us know if you need more assistance, or if you found a solution, it may help others in the future!