I have this
syntax = "proto2";
message SkuCostAudit {
message costs{
required string calculatedDateTime = 1;
required int64 sku = 2;
required int64 vendor = 3;
required int64 location = 4;
required string locationType = 5;
required float cost = 6;
required string effectiveBeginDateTime = 7;
required string effectiveEndDateTime = 8;
required string transactionType = 9;
repeated details details = 10;
}
message details{
required string type = 12;
required float cost = 13;
required string effective = 14;
}
repeated costs xyz = 11;
}
Still getting error
Invalid JSON-encoded message against Protocol Buffer schema. Syntax error:
value, object or array expected.
On Tuesday, November 29, 2022 at 10:51:27 PM UTC-5 [email protected] wrote:
> Say “repeated” instead of “required” for details/10 line.
>
> On Tue, Nov 29, 2022 at 7:39 PM 'SUDHAVANI SUNKARA' via Protocol Buffers <
> [email protected]> wrote:
>
>> Thank you DE.
>>
>> I tried this still same isuue
>>
>> syntax = "proto2";
>>
>> message SkuCostAudit {
>> message costs{
>> required string calculatedDateTime = 1;
>> required int64 sku = 2;
>> required int64 vendor = 3;
>> required int64 location = 4;
>> required string locationType = 5;
>> required float cost = 6;
>> required string effectiveBeginDateTime = 7;
>> required string effectiveEndDateTime = 8;
>> required string transactionType = 9;
>> required details details = 10;
>> }
>> message details{
>> required string type = 13;
>> required float cost = 14;
>> required string effective = 15;
>> }
>> repeated costs xyz = 11;
>> }
>>
>> On Tuesday, November 29, 2022 at 10:33:34 PM UTC-5 [email protected]
>> wrote:
>>
>>> Looks like details needs to be a repeated message with its own schema
>>> and you have it set to required and string.
>>>
>>> On Tue, Nov 29, 2022 at 7:30 PM 'SUDHAVANI SUNKARA' via Protocol Buffers
>>> <[email protected]> wrote:
>>>
>>>> Hi
>>>>
>>>> I am trying to use BQ subscription to write into BQ table. I am using
>>>> pubsub schema and trying to use protocol buffer option.
>>>> Here is my schema
>>>>
>>>> syntax = "proto2";
>>>>
>>>> message SkuCostAudit {
>>>> message costs{
>>>> required string calculatedDateTime = 1;
>>>> required int64 sku = 2;
>>>> required int64 vendor = 3;
>>>> required int64 location = 4;
>>>> required string locationType = 5;
>>>> required float cost = 6;
>>>> required string effectiveBeginDateTime = 7;
>>>> required string effectiveEndDateTime = 8;
>>>> required string transactionType = 9;
>>>> required string details = 10;
>>>> }
>>>>
>>>> repeated costs xyz = 11;
>>>> }
>>>>
>>>> I am trying to test my schema with this pubsub message..
>>>>
>>>> {
>>>> "costs":[
>>>> {
>>>> "calculatedDateTime":"2022-11-29T15:38:47Z",
>>>> "sku":122222222,
>>>> "vendor":111111,
>>>> "location":1234,
>>>> "locationType":"",
>>>> "cost":200.1200,
>>>> "effectiveBeginDateTime":"2019-12-25T07:00:00Z",
>>>> "effectiveEndDateTime":"2022-11-17T06:59:59Z",
>>>> "transactionType":"INSERT",
>>>> "details":[
>>>> {
>>>> "type":"PERMANENT",
>>>> "cost":200.1200,
>>>> "effective":true
>>>> }
>>>> ]
>>>> },
>>>> {
>>>> "calculatedDateTime":"2022-11-29T15:38:47Z",
>>>> "sku":222222222,
>>>> "vendor":222222,
>>>> "location":2222,
>>>> "locationType":"",
>>>> "cost":45,
>>>> "effectiveBeginDateTime":"2022-11-17T07:00:00Z",
>>>> "effectiveEndDateTime":"2023-11-24T06:59:59Z",
>>>> "transactionType":"INSERT",
>>>> "details":[
>>>> {
>>>> "type":"PERMANENT",
>>>> "cost":45,
>>>> "effective":true
>>>> }
>>>> ]
>>>> },
>>>> {
>>>> "calculatedDateTime":"2022-11-29T15:38:47Z",
>>>> "sku":3333333333,
>>>> "vendor":44444444,
>>>> "location":2222,
>>>> "locationType":"",
>>>> "cost":200.1200,
>>>> "effectiveBeginDateTime":"2019-12-25T07:00:00Z",
>>>> "effectiveEndDateTime":"9999-12-30T23:59:59Z",
>>>> "transactionType":"DELETE",
>>>> "details":[
>>>> {
>>>> "type":"PERMANENT",
>>>> "cost":200.1200,
>>>> "effective":true
>>>> }
>>>> ]
>>>> }
>>>> ]
>>>> }
>>>>
>>>> I am getting error "Message is invalid against schema" . My pubsub
>>>> message is correct. Can someone guide me to fix my schema?
>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "Protocol Buffers" group.
>>>>
>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to [email protected].
>>>> To view this discussion on the web visit
>>>> https://groups.google.com/d/msgid/protobuf/de950a92-ffe3-4796-b1c4-ba22f290d70an%40googlegroups.com
>>>>
>>>> <https://groups.google.com/d/msgid/protobuf/de950a92-ffe3-4796-b1c4-ba22f290d70an%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>> .
>>>>
>>> --
>> You received this message because you are subscribed to the Google Groups
>> "Protocol Buffers" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected].
>>
> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/protobuf/419ea2b1-64a4-4c4b-8561-2fba4e158db6n%40googlegroups.com
>>
>> <https://groups.google.com/d/msgid/protobuf/419ea2b1-64a4-4c4b-8561-2fba4e158db6n%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>>
>
--
You received this message because you are subscribed to the Google Groups
"Protocol Buffers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/protobuf/92d9a6ab-0bf0-4560-b4b7-360134938f17n%40googlegroups.com.
