ViaCep | Um módulo para a consulta | Runtime Evironment library

You're mixing async models between callbacks and async/await methodology. Instead, try this (using superagent, which has async native mechanisms, to simplify the code I'm writing):

Your code is right but you are using PHP in js to call a method there are 2 ways 1st: pass value from PHP to js and call method from js

This code will insert all 10 values from the JSON into the table Requisicao and 0 for both validation and created, though that can be changed.

You don't seem to be using any library that handles dynamic mapping of your parameters to the required ordinal format into the query itself(like pg-parameterize) so the line:

const sql = 'INSERT INTO public.city(cep, logradouro, complemento, bairro, localidade, uf, ibge, gia, ddd, siafi) VALUES ?';

and more specifically the VALUES ? part shouldn't be doing anything useful. Change that to:

const sql = 'INSERT INTO public.city(cep, logradouro, complemento, bairro, localidade, uf, ibge, gia, ddd, siafi) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10)';

as the pg npm package is using ordered parameters for parameterized queries.

Checkout the "Parameterized query" section in the docs for queries.

You're either inserting the new record or getting an error. There is no other option. If you don't see any new record in the db after refresh, then you're just swallowing the error result in your code. As you're going the async/await promise route, the code await pool.query(sql, values); will throw if something goes wrong.

Then, in your caller:

You have created a high-order function by returning a function in verificaCache(), so to properly call it you need to do it like that await verificaCache(cep)(req, res), remember, the first time you call it, you have a function being returned, since you want the tasks inside of that function to be executed, you need to call it as well.

Take a reading about high-order functions here: https://blog.alexdevero.com/higher-order-functions-javascript/

My recommendation, you could just get rid of the other function you are returning to simplify your code, and let the service only handle business logic, all the http actions should be handled on the controller level:

This is a known issue caused by a cyclic dependency with the HttpInterceptor and the HttpClient.

HttpClient has a dependency on all HttpInterceptors.
AuthService has a dependency on the HttpClient.

Injecting the AuthService in the HttpInterceptor will create an infinite loop.

1. Change the 3 Text elements to TextField.
2. Define 3 TextEditingControllers and assign them to the TextFields.
3. In your recuperarCep method, instead of setting the variables to the obtained values, set the corresponding TextField's controller's 'text' property to the value.