Get Representation does not work for word and excel

[ManasaMS85]

BOXRepresentationHints API - has only 3 options -
extern const BOXRepresentationHints BOXRepresentationHintsDefaultThumbnails;
/// A good preview for most file types. Maybe more than one preview representation
/// (currently at least the first available of PDF, HLS, MP4, MP3 or JPG)
extern const BOXRepresentationHints BOXRepresentationHintsDefaultPreview;
/// Both thumbnails and the preview defined above
extern const BOXRepresentationHints BOXRepresentationHintsDefaultThumbnailsandPreview;

I need to show high quality image and pdf, word and excel's first page - the option selected - BOXRepresentationHintsDefaultPreview works for images and PDF but doesnot work for word and excel . Is their any way or API which gives me all of these options

[ManasaMS85]

The Previous version of SDK had support for Word and Excel

[mattwiller]

@ManasaMS85 You can pass any arbitrary string of representation hints, and do not need to reply on the defaults provided. Please see the Representations API documentation for more information and examples of how to construct the hints string.

If you want both a high-res image and PDF, something like "[pdf][png?dimensions=2048x2048]" might work for you

[jlawton]

As Matt points out, you can select your representations with a custom string.

The way that representations work, they will only include the formats that Box converts to. If you actually want the original Word or Excel file, representations are not what you want. There's a download API for that.

[ManasaMS85]

@jlawton - i do not want the original Word or Excel file representation. All i was telling was - BOXRepresentationHintsDefaultPreview does not convert word doc and excel files representation to PDF

The enum BOXRepresentationHintsDefaultPreview - does the same, it should represent any PDF, word, excel in the PDF representations - Which is not working

/// A good preview for most file types. Maybe more than one preview representation
/// (currently at least the first available of PDF, HLS, MP4, MP3 or JPG)
extern const BOXRepresentationHints BOXRepresentationHintsDefaultPreview;

As well coming to @mattwiller suggestion - Setting the string : "[pdf][png?dimensions=2048x2048]"
throws below error:

fileInfoRequest?.representationHints = "[pdf][png?dimensions=2048x2048]"

Error Domain=com.box.contentsdk.errordomain Code=404 "(null)" UserInfo={com.box.contentsdk.jsonerrorresponse={
code = "not_found";
"help_url" = "http://developers.box.com/docs/#errors";
message = "The given asset path is unsupported for 'png_paged_2048x2048' representation.";
"request_id" = pbbtv9g07vlzjbi4;
status = 404;
type = error;
}}

Individually the PDF works fine and the PNG works fine

[mattwiller]

@ManasaMS85 It looks like the PNG representation is causing issues because it's a multi-asset representation (one image per page of the document). You may need to specify that you want the un-paged version with hints like this: [pdf][png?dimensions=2048x2048&paged=false]

[jlawton]

@ManasaMS85 I expect the default preview representations to include PDF. If this is not happening, then this is an API bug. We will attempt to reproduce the problem and forward the bug in that case. I'm glad, at least, that the representations are working individually for you.

[ManasaMS85]

@jlawton - Word and Excel was not showing up on the PDF option individually as well. Representation with string "[pdf][png?dimensions=2048x2048&paged=false]" was not working together because of paged issue as @mattwiller pointed.

Neither this change helped me to fetch the representation of word and excel - ideally "BOXRepresentationHintsDefaultPreview" should have fetched it

[ManasaMS85]

@jlawton - Could you check this issue at your end - representation of word and excel?

[mattwiller]

@ManasaMS85 Could you provide us the ID of a Word or Excel file where the PDF representation is not available, so we can look into the issue on our end?

[ManasaMS85]

file id for an excel : 403122468801

[jlawton]

Matt will follow up, but I did check on some documents I own, and representations works as expected, so it appears not to be a general problem.

[mattwiller]

@ManasaMS85 I'm currently checking with our internal Conversion team to see if there's any issue with how the PDF representation is created for that file.

[mattwiller]

@ManasaMS85 Our server logs indicate the a PDF representation was correctly generated for that file on Feb. 15th. Is this file still not working for you? If possible, can you make the API request for representations manually and let us know what the response looks like? You can use a tool like Postman or the following curl command:

curl -H "Authorization: Bearer PASTE_ACCESS_TOKEN_HERE" \
-H "X-Rep-Hints: [pdf]" \
https://api.box.com/2.0/files/403122468801?fields=representations

[ManasaMS85]

{"type":"file","id":"403122468801","etag":"0","representations":{"entries":[{"representation":"pdf","properties":{},"info":{"url":"https://api.box.com/2.0/internal_files/403122468801/versions/426246046401/representations/pdf"},"status":{"state":"success"},"content":{"url_template":"https://public.boxcloud.com/api/2.0/internal_files/403122468801/versions/426246046401/representations/pdf\MN-C02V6269HTD8:AllstateMobMN-C02V6269HTD8:AllstateMN-C02MN-C02V6269HMN-C02

Not sure why the same thing does not work in the app

[mattwiller]

@ManasaMS85 What does the code you're using to get the representations using the SDK look like, and what results does that code produce? It seems like the API side of things is fine, so perhaps this is an issue with how the SDK is making the API request or interpreting the results.