Tencent/APIJSON

[咨询] 添加接口调用post时数据库中json字段如何表示

Open

#838 opened on Aug 22, 2025

View on GitHub
 (1 comment) (0 reactions) (0 assignees)Java (17,967 stars) (2,229 forks)batch import
Document 文档Enhancement 增强Question 使用问题help wanted

Description

Description

{{url}}/apijson/post { "ComplexPoly4OffsetLib" : { "id" : null, "uuid" : "0198d0a1-6302-70e5-adee-2a49d3446a8b", "full_entity_key" : "Fdm20-Rpc-dev_760300368696180736_760299724456656962", "from_sys" : "Fdm20-Rpc-dev", "order_id" : null, "order_code" : null, "batch_id" : "760300368696180736", "batch_code" : "YFceshi20250721001", "entity_key" : "760299724456656962", "entity_code" : "S250721990920-1001", "duplicate" : null, "poly" : { "type" : "Shape" }, "poly_md5" : "a07676153f6ffa7e8381de8614ec3d76", "edge_count" : 12, "edge_offset_list" : [ 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0 ], "model_build_time" : "2025-07-21 10:16:54", "import_time" : null, "create_time" : null, "update_time" : null }, "tag": "ComplexPoly4OffsetLib" } 请教一下，我想往数据库里新增一条记录，poly是mysql json字段类型， 发送的数据里，poly用{}来表示，数据库里写不进去，改用json字符串，可以写入进去，有没有比较好的办法，用字符串的方式，对前端不太友好

Contributor guide

Tech stack
javasqlmysql
Domain
backenddatabaseapi
Issue type
research
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
under 1 hour
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
fresh
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
Basic understanding of APIJSONFamiliarity with MySQL JSON data type
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
85
Research direction
Investigate how APIJSON handles JSON field insertion. Check the official documentation for JSON field types and examples in the codebase. See if there is a special annotation or parsing rule for nested JSON objects in POST requests. Consider whether the input format should accept a JSON object directly and convert it to a string automatically. Also, look at existing tests for similar cases.