FolderId in Salesforce Macro Object/Entity is available when “Share and organize macros in folders” is enabled in Macro Settings.

Sample SOQL:

SELECT Id, FolderId
FROM Macro