Get values from database

[I-SER-I]

I want to get all values ​​from the database. But for some reason, i only see the names of the properties, and the values ​​are empty

Example Table

[KoditkarVedant]

@I-SER-I you need to use the Query API on the database to get all values (i.e. rows - pages in the terms of Notion).

[I-SER-I]

Many thanks

[dtwarogpl]

@KoditkarVedant I'm stuck in exactly same situation. Could you provide any code example?

[I-SER-I]

@KoditkarVedant I'm stuck in exactly same situation. Could you provide any code example?

var queryParams = new DatabasesQueryParameters { Filter = null }; var pages = await client.Databases.QueryAsync(databaseId, queryParams);

source

databaseId u can get on Databases property

[dtwarogpl]

@I-SER-I This is exactly what I have done:

`
public async IAsyncEnumerable DoSomething()
{
var client = NotionClientFactory.Create(new ClientOptions
{
AuthToken = AuthTokentoken
});

 var queryParams = new DatabasesQueryParameters { Filter = null }; var pages = await client.Databases.QueryAsync(dbKey, queryParams); foreach (var Page in pages.Results) { foreach (var property in Page.Properties.Where(x => x.Value.Type!=PropertyValueType.Title)) { if(property.Value is RelationPropertyValue relationProperty) { yield return string.Join(",", relationProperty.Relation.Select(x => x.Id.ToString())); } yield return property.Key + " - " + property.Value.Id + " - " + property.Value.Type; } } }` 

When my Notion database looks like this:

I should be able to see those related pages but they are not there:

Marked filed should give me 'Relation1Page'

[dtwarogpl]

Ok, solved by myself. Maybe this would be helpfull for anyone in future. In my case there were always empty relations. I had to enable my related table in Notion to use same integration as parent.