Hard to say without seeing more details/code. Sorry :(
On Tue, Nov 29, 2022 at 7:54 PM 'SUDHAVANI SUNKARA' via Protocol Buffers <
[email protected]> wrote:
> 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
> <https://groups.google.com/d/msgid/protobuf/92d9a6ab-0bf0-4560-b4b7-360134938f17n%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/CAD7-yfva4sXxbxzSj7i3rq_p75c50Q6US9LAQp3%2BiO0wBWTJnQ%40mail.gmail.com.
