Hi Experts,
I have a requirement in order to push data into C4C using SAP BODS via web services call. The format it is expecting is something I am not able to generate using BODS.
This is the format of the payload which the system is expecting-
DS_NAME
MERGE
PROD;PROD_NAME;DC;DC_NAME;AMT_MTD;
3;XY;19;DC-19;1000.00;
3;XY;19;DC-19;2000.00;
4;YZ;20;DC-20;3000.00;
4;YZ;20;DC-20;4000.00;
I am able to generate this format-
[b]
DS_NAME
MERGE
When I check with the developer from C4C, he tells me that the format is generated by SAP and they cannot change it to be able to handle the one which they receive from BODS.
Can any one please help? we have a decision to make on this if we have to move to .net programing to able to push the data or there can be possibility in BODS
I am not sure if you can do this in mapping or transform, i.e. convert set of rows to buffer, but you could try this in multiple DF, you can dump the expected output to a file with single column in one DF and in the next DF read that file and map the single column to Data
use a non-printable character, or any character that you don’t expect to be part of data a row delimiter
PROD;PROD_NAME;DC;DC_NAME;AMT_MTD;
3;XY;19;DC-19;1000.00;
3;XY;19;DC-19;2000.00;
4;YZ;20;DC-20;3000.00;
4;YZ;20;DC-20;4000.00;
Hi Manoj,
I tried with that option too. The issue is I cannot make BODS to able to push a data in 1X1 table format.
i.e.- all these 3 lines is nothing but a single row
PROD;PROD_NAME;DC;DC_NAME;AMT_MTD;
3;XY;19;DC-19;1000.00;
3;XY;19;DC-19;2000.00;
Though I use chr(10) in my query transform, and use a different character to be able to have a row delimiter, the output result is always this-
PROD;PROD_NAME;DC;DC_NAME;AMT_MTD; 3;XY;19;DC-19;1000.00; 3;XY;19;DC-19;2000.00;
everything is coming in one single line. How to get multiple line with in the data and yet treat the whole set of data as a dataset in a single row.
Experts,
Can you please tell me if you have encountered this case?
I changed the value under MDAVName which contains the datasource details. Gave a value- XYZ which is not a valid datasource. I ran the xml using SOAPUI and the response came back as “Datasource XYZ doesn’t exist”. I ran the job in BODS using the datasource name as XYZ. Instead of throwing the error as datatsource XYZ doesn’t exists, it is giving me error as “Datasource doesn’t exists”. this means whatever value I am passing under the parameter MDAVName, webservices(C4C) is reading it as null or empty string.
Does it mean that some kind of plugin is missing??