I am building the REST API service in a no-code platform. I have JSON output in REST Service which I need to convert into CSV format.
Below is the output after the basic authentication
d
results
0
__metadata
uri "https://xxxx.com/os/odata/ana_businessanalytics_analytics.svc/RPFINGLAU08_Q0002QueryResults('%7CCPOSTING_DATE%3D18.11.2020%7CCSP_CDT_F_DATE%3D08.12.2020%7CCCINHUUID%3D1INV-10-2020%7CCBUS_PART_UUID%3DCS200128%7C')"
type "sapbyd.RPFINGLAU08_Q0002QueryResult"
CBUS_PART_UUID "CS200128"
CCINHUUID "1INV-10-2020"
CPOSTING_DATE "/Date(1605657600000)/"
CSP_CDT_F_DATE "/Date(1607385600000)/"
KCOPEN_CURRLIT "1330"
TBUS_PART_UUID "William & Sons"
1
__metadata
uri "https://xxxx.com/os/odata/ana_businessanalytics_analytics.svc/RPFINGLAU08_Q0002QueryResults('%7CCPOSTING_DATE%3D18.11.2020%7CCSP_CDT_F_DATE%3D08.12.2020%7CCCINHUUID%3D1INV-11-2020%7CCBUS_PART_UUID%3DCS200128%7C')"
type "sapbyd.RPFINGLAU08_Q0002QueryResult"
CBUS_PART_UUID "CS200128"
CCINHUUID "1INV-11-2020"
CPOSTING_DATE "/Date(1605657600000)/"
CSP_CDT_F_DATE "/Date(1607385600000)/"
KCOPEN_CURRLIT "2400"
TBUS_PART_UUID "William & Sons"
Expected Result in CSV
Results,CCINHUUID,TBUS_PART_UUID,KCOPEN_CURRLIT,7CCPOSTING_DATE%3D,7CCSP_CDT_F_DATE%3D 0,William & Sons,1300,18.11.2020,08.12.2020 1,William & Sons,2400,18.11.2020,08.12.2020
Can Some give me help to convert this format?
Regards Janarthanan