Unable to load data from pre-signed S3 url because Flexmonster is appending a random parameter

Answered
Ankit Agarwal asked on September 20, 2023

We have the Flexmonster pivot setup to load CSV data from files we are hosting on S3. The S3 bucket and all objects inside are NOT public, so to give access, we are generating pre-signed S3 URLs for the csv files.
 
However, when the Flexmonster pivot attempts to load the file, it is appending a random numeric parameter (like '&470898116') to the pre-signed S3 url. This makes it an invalid url as S3 pre-signed URLs ONLY work as-is, and nothing can be changed with them.
 
Is there a way to prevent Flexmonster from appending this numeric value to the file url (we specify in dataSource.filename)?

3 answers

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster September 21, 2023

Hello, Ankit!
 
Thank you for contacting us.
 
Kindly note that Flexmonster adds this randomly generated query parameter to prevent loading the file from the browser's cache. You can disable this feature by enabling the allowBrowsersCache option as follows:

report: {
      options: {
        allowBrowsersCache: true,
        //other options
      },
      //other report properties
}

 
Please let us know if the following approach works for your case.
Looking forward to hearing from you.
 
Kind regards,
Solomiia

Public
Ankit Agarwal September 21, 2023

Thanks Solomiia; that option did the trick.

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster September 22, 2023

Hello, Ankit!

Thank you for your feedback.

We are glad to hear that the suggested approach works well for you.

Do not hesitate to contact us in case of any other questions.

Kind regards,
Solomiia

Please login or Register to Submit Answer