cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

SAC Dimension API Issue

MK57
Newcomer
0 Likes
24

Hi Team,

We are using SAC API to download Cost Center/GL Account/Customer dimension. These APIs exported files in CSV format with comma separator.

We are using comma in the Cost Center/GL Account/Customer description as well which is creating issue here.

Can we change with comma separator in CSV file like | to avoid above issue.

Regards,

Mahesh

Accepted Solutions (0)

Answers (1)

Answers (1)

N1kh1l
Active Contributor
0 Likes

@MK57 

You can configure the delimiter in the API url by setting $format=text/csv&delimiter=%7C

%7C is delimiter hex code for "|"

You can check the documentation below.

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/14cac91febef464dbb1efce20e3f1613/db13b8e75e7443a7a3332...

 

Hope this helps!

Nikhil