Send Downlink SQL request

ChirpStack Network Server
1

Good afternoon friends. I am new to work with ChirpStack and I have a problem when sending DownLink to a device, I need to send a message like HEX “0С01” in BASE64 “DAE =”

1
11078×533 14.6 KB

Everything works correctly through the WEB, but I need to send the same message directly through the SQL query to the ChirpStaсk database

Here is my request to create a downlink entry:

INSERT INTO device_queue (id,created_at, updated_at, dev_eui, frm_payload, f_cnt, f_port, confirmed, is_pending, timeout_after, emit_at_time_since_gps_epoch, dev_addr, retry_after) VALUES (‘888’, ‘08.11.2021 18:23:40’, ‘08.11.2021 18:23:40’, decode(‘0000000000000002’, ‘hex’), ‘DAE=’, ‘1’, ‘4’, ‘FALSE’, ‘FALSE’, null, ‘0’, decode(‘01CAA576’, ‘hex’), ‘01.01.0001 0:00:00’)

And I get the wrong base64 value

2
21084×167 4.55 KB

Tell me how to send downlink via SQL request?

2

Please don’t do this. The database schemas are subject to change, and Postgres isn’t the only place that ChirpStack stores data and state.

1 Like
3

Please tell me where you can learn more about the principle of forming a Downlink package?
Do I understand correctly that DOWNLINK can only be sent via WEB or MQTT?

4

You can use the REST api to do that.

2 Likes
5

Thanks! The solution with the REST API turned out to be successful.

1 Like