What values import sent
What values import sent
Messages from import (source = 'import') in raw_inbox always contain valid JSON, but the value inside is not necessarily an object. Unpack these parcels and show what kind of JSON value arrived in each one.
What to return:
- msg_id — the message ID
- json_type — the value type as PostgreSQL names it: object, array, string, number, boolean or null
Keep in mind:
- body is stored as plain text
- include only messages with source = 'import'
- leave out other sources: some of their bodies do not parse as JSON
Sort by msg_id ascending.
Row order matters
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid