Publish to the Web (Data Feed)

Publishing to the Web

If you want to share an Excel file of your records with others, you can use Publish to the Web. This will generate a link that allows others to download the Excel file directly. For example, you can enable customers to download their order data themselves.

Navigate to Listing Page > Tools > Publish to The Web under the Report section.

You need to configure the correct Access Rights for the EVERYONE group to allow others to download records via this link. Note that changing Access Rights for the EVERYONE group will also affect Access Rights for the entire sheet.

If you haven't made your sheet public through the Access Rights settings, you'll have two options:

1. Set access right of group EVERYONE to Viewer

This will make the sheet publicly viewable, but users will not be able to add or modify records. Also, ensure that EVERYONE group has the "Download Listing Page" feature access. You can change the Access Rights at any time.

You can select fields from the Listing Page or all fields to publish and choose whether to apply a saved Shared View.

To stop publishing, set the EVERYONE group to No Rights or Survey User in this window. This way, you don’t need to navigate to Design Mode.

2. Generate link with API key

This will generate a link using the API key with the current user's Access Rights.

Anyone with the link can access the database with the same rights as the user who generated the API Key. Therefore, it is recommended to create a separate account specifically for generating API Keys and grant it the proper Access Rights. This helps avoid accidental logouts or incorrect access settings.

You can also select fields from the Listing Page or all fields to publish and choose whether to apply a saved Shared View.

If you want to use an API Key from a different account, log in to that account first and follow this section to obtain the API Key. Once you have the API Key, append it to the URL after APIKey=.

Publishing Specific Fields to the Web

If you want to publish only specific fields to the web, you can use the ?f=cust&s=1000&order=["field_id",...] parameters (To find field_id, please refer to this documentation). Add the parameter to the URL generated for publishing to the web.

Example:

1. If the generated URL is:

https://www.ragic.com/ExampleAccount/Tab1/18.xlsx

2. You want to include data only from fields with IDs "1000231" and "1000243".

3. Add the parameters to the URL to specify fields:

https://www.ragic.com/ExampleAccount/Tab1/18.xlsx?f=cust&s=1000&order=["1000231","1000243"]