API search TO TABLE RT

General Discussions - English
1

I have my rt table, but when using the API to query 9312/search, it tells me that my table is unknown, what am I doing wrong please?

{
“index”:“advertDup”,
“texto”:“ortis”
}

2

Where do you see you have it?

3

when making show tables; my created index is shown

4

Please help, I have reviewed the manticore documentation several times and I cannot configure my table or rt index to be able to consult it through the API, it works for me to insert using /ip:9312/insert, but it does not work for me using /ip :9312/search, sorry to bother but can you please help me with a step by step guide, suddenly the translation is failing, please friend I need urgent help, thank you

5

this is my manticoreconf
searchd {
listen = 10.1.23.16:9312
listen = 10.1.23.16:9306:mysql
listen = 10.1.23.16:9308:http
log = /var/log/manticore/searchd.log
query_log = /var/log/manticore/query.log
pid_file = /run/manticore/searchd.pid
query_log_format = sphinxql
binlog_path = /var/lib/manticore/binlog
collation_server = utf8_general_ci
#data_dir=/opt/manticore/data
}

source BADALEX1_ADVERTDUP {
type = odbc
odbc_dsn =DRIVER={ODBC Driver 18 for SQL Server};SERVER=10.1.27.21\DESA03;DATABASE=BADALEX1;UID=SCRIPT;PWD=SCRIPT;TrustServerCertificate=Yes
sql_query = SELECT * FROM CLEX1.AdvertDup;
sql_attr_uint=idAdvertDup
sql_field_string=idlayer
sql_field_string=nombreTipo
sql_field_string=nombre
sql_attr_uint=idMovimiento

}

index advertDup{
type=plain
source = BADALEX1_ADVERTDUP
path =/opt/manticore/data/advertDup
#stopwords= es, la
}

now problem is no API search, “error”: “unknown local table(s) ‘advertdup’ in search request”

6

Please provide your full request and response.