Hi Experts
This is kind of a trivial question. I am trying to create a csv file map for integration, and in this I have a function setup. I’m trying to extract values from the csv to send to this function. In xml we do something like {xpath:parameter}, what is the equivalent for a csv file?
+26
Hi
What exactly are you trying to extract? Have an example?
Cheers!
So as per the screenshots I posted, I’m trying to get the values from the csv file for those respective fields and pass it on to the integration function.
In the example above, first row of csv:
supplier (TRN_SUP04)
address_id (1121)
phone (452544356)
+26
Isn’t the mapping section enough?
Again, I am not sure what you are trying to do.
If this is a flat file processing, you should map between the CSV column and FSM fields.
Something like below
Cheers!
Yes, for most of the fields I use the mapping tab, which works fine.
The scenario here is, I’m trying to create a part with a supplier part. when I do this, if the supplier does not exist I want to create the supplier first using a process (integration function) and then use the created supplier_id in the supplier part creation. so, I am trying to pass the values needed for the supplier creation function, from the csv.
Did you try using the {xpath:supplier}, {xpath:address_id} and {xpath:phone}? (instead of using {supplier}, {address_id} and {phone} in your process arguments)
I have also tried to use the below csv map with the integration map function as shown below.
Even though this is csv flat file map, I could get the value by using the same xpath method. Please see the below function information as well.
Integration map function
Integration run log
Thanks,
Hasara
The reason I am using an xml function is because I want to extract a value from the function response and set it to a field and this needs to be done before mapping.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
