Making CPQ API JSON response pretty / readable

inspired27 commented 1 year ago

Hi,

Thanks for providing this repo and the Salesforce API's. Is there any way to make the Salesforce API JSON response pretty, I have read a quote with MDQ segments etc using Read API and there a lot in the JSON however not matter which viewer I use it does not format it in a pretty readable way it is hard to understand:

Example of the output not matter what viewer I try , ugly:

pozil commented 1 year ago

Hi @crazyfrog-github, there's a Postman feature for formatting the JSON output of the response. Have you tried to open the Pretty tab in the response view? Screenshot 2023-04-28 at 10 26 02

inspired27 commented 1 year ago

Hi,

Yes very first thing but it still looks terrible nothing like the pretty JSON you have above:

pozil commented 1 year ago

Oh wow, looking at the body of your response I can see that it's not JSON, it's a string that contains JSON (see the first double quote). That's why the Postman parser can't handle it.

What's the Content-Type header value for the response?

For the record, I'm not familiar with CPQ but I'll try to help.

inspired27 commented 1 year ago

G'day Philippe,

Below are the details, requested with response info. What is so special about the quote API that makes it come back ugly, any help to make it pretty and understandable would be great.

Response Headers:

@.***

Response Body:

@.***

From: Philippe Ozil @.> Sent: Friday, 28 April 2023 7:24 PM To: forcedotcom/postman-salesforce-apis @.> Cc: crazyfrog-github @.>; Mention @.> Subject: Re: [forcedotcom/postman-salesforce-apis] Making CPQ API JSON response pretty / readable (Issue #66)

Oh wow, looking at the body of your response I can see that it's not JSON, it's a string that contains JSON (see the first double quote). That's why the Postman parser can't handle it.

What's the Content-Type header value for the response?

For the record, I'm not familiar with CPQ but I'll try to help.

- Reply to this email directly, view it on GitHubhttps://github.com/forcedotcom/postman-salesforce-apis/issues/66#issuecomment-1527258235, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AICL2BMAYX3BCETMA6H6LK3XDOEDNANCNFSM6AAAAAAXO5BMAE. You are receiving this because you were mentioned.Message ID: @.**@.>>

inspired27 commented 1 year ago

Hi,

Sorry not sure what happened but the images of postman headers did not save. Hopefully you can see the Content-Type header now, attached again:

pozil commented 1 year ago

It really looks like a bug on the server side to me. Despite the response header saying that this is JSON, you can see that this is a String with escaped JSON (you can see the escaped inner quotes \"). The problem isn't Postman here, it's the response format sent by the server. I believe that the response data was JSON-encoded twice.

You can reproduce a similar pattern with this code

Account a = new Account(Name='test account');
String json = JSON.serialize(a);
String doubleEncoded = JSON.serialize(json);
System.debug(doubleEncoded);

This outputs a string which wouldn't be properly formatted:

"{\"attributes\":{\"type\":\"Account\"},\"Name\":\"test account\"}"

inspired27 commented 1 year ago

Thanks, if you use the read product CPQ API do you get the same response JSON encoded twice?

pozil commented 1 year ago

I don't have access to a CPQ environment but I'll ask around if I can find someone who can chime in.

forcedotcom / postman-salesforce-apis

Making CPQ API JSON response pretty / readable #66