Static Link with Dynamic Data

harshav over 7 years ago

Hi All,
I have a scenario, where Lets say I am dealing with Case management, as of today the Application has an action and the action contains different filter criteria like A, B , C are the selected filter criteria. Now after selection we have an option for Generate Link, Imagine that , The link is pointing towards the Excel sheet which contains the 500 rows of satisfied filter criteria.( User is given only the link to that excel sheet which is a static link)

Now my Use case is user copies that link and sends to someone else in the team. user B who received this link will open the link 2 days after.
But now in these 2 days there are extra 200 cases created with all the filters satisfied.

Is there a way where I can include all these extra 200 cases also into already generated excel sheet when user B clicks on that link. If so please let me know the solution.
Or else does anyon...

Discussion posts and replies are publicly visible

0 harshav over 7 years ago

...e have a other solution which can give me the data which will export all the 700 rows data with the filters which are already been selected.

TIA :)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 TJ
A Score Level 2
over 7 years ago

You can use 'create excel by template' smartservice and use override existing excel sheet option. This would allow you to override same excel sheet without any change of link.
Hope this helps!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 harshav over 7 years ago

Thanks for the input, But my question is user is not going to click again on generate Link he is only going to click on the link which the sheet is already having the data, I mean like the link will be something "urappian.com/.../docId which is my excel sheet.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Stefan Helzle
A Score Level 3
over 7 years ago

You could create a web API that returns the data as CSV. There is an example like this when you create a new web API. In there you can read the provided parameters and filter the data accordingly.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Josh
Certified Lead Developer
over 7 years ago

To echo what @stefanh791 has said, we have also successfully used Web APIs to serve up dynamic data via a static link.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 harshav over 7 years ago

Thanks Stefan and josh for the inputs, we are in version 7.8 which I forgot to mention sorry for that. But is there any way other than WEB API.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Mike Schmitt
Certified Lead Developer
over 7 years ago

If the only constraint you're running into has to do with new records added after the original link is generated, how about adding an invisible dateTime filter to the initial query that only returns records created up until that point? Then if someone downloads using the same link a few days later, any new ones would not be included in the filter. I'm assuming that all record rows have some sort of "created date" automatically generated at time of creation. Then again, even if not, you could also query for the highest primary key ID at the time of creation, and filter on that instead.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel