SharePoint Search REST API does not return custom columns values

Question

I've been trying to use SharePoint REST API to retrieve a number of files on my site but for some reason, if it does tell me the name or descriptions of the files, it returns null for every single custom columns I have for those files.

Here's the code I use:

const path = "Path:" + AppState.context.pageContext.web.absoluteUrl + "/* ";
const url = AppState.context.pageContext.web.absoluteUrl + "/_api/search/query?querytext='" + path + "IsDocument:true'&selectproperties='Status,Title,Path,Created,Description,MGS_Hierarchy'";

and here are the example of a result:

As you can see, the "Status" and "MGS_Hierarchy" values are null, even tough they are set in the list:

The two columns are inherited from a custom content type. I don't know if it changes something.

Any help is greatly appreciated.

Answer 1

You have to use the managed property names for the custom columns to retrieve custom column values using SharePoint Search REST API.

Make sure you are using correct managed property names for the custom columns.

You can find the managed property names from Search Schema in site settings.

Follow below links for more information:

1. How to Identify Custom Property Names in SharePoint
2. SharePoint Search REST API overview