Queue containing Objects in json schema not populating

Feedback Apps
, ,
1

Hi there,

I have been developing an advanced process, and ideally I would like to be able to submit a table that has been populated forma custom list.

I have set the Test Queue with the following schema:

{
    "definitions": {},
    "$schema": "http://json-schema.org/draft-07/schema#",
    "$id": "http://example.com/root.json",
    "type": "object",
    "title": "The Root Schema",
    "required": [
        "TestString","TestObject","AnotherTest"
    ],
    "properties": {
        "TestString": {
            "type": "string"
        },
        "TestObject": {
            "type": "object"
        },
        "AnotherTest": {
            "type": "string"
	}
        }
    }

Yet when I go to the App itself, and try to find the TestObject variable, it does not appear in the schema at all

image
image1256×113 4.75 KB

Can someone explain how I can submit a table of data/fields to a queue to be parsed/used by one of my robots?

3

@LewisHenderson ,

Queue doesn’t support complex object type. This support only simple field if you are passing complex object then you need to pass as string value.

I see you are passing a field as type object so in that case Apps does not support it.

If you want to send a date-time object, datatables, objects, or arrays to a queue, make sure that you bind it to a string type field. You can also bind a complex object to a queue input using the string type field.

Thanks,
Arvind

1 Like
4

Thanks @Arvind_Kumar1 .

I have adjusted my schema to be a string, but the data table seems to violate input criteria. I have added an hidden text box with the table bound to it, and the value is my input for the queue.

How is best to get my data table type to cast as a string?

5

@LewisHenderson ,

Once queue is added for complex object you will have to split the string and loop it and assign the value into data table.

Try below steps.

  1. Build data table
  2. Assign activity to split the string into an array (splitting by spaces)
  3. Add Data Row activity
    → In the property window you can find Array Row, add your array in that field
  4. Sort data table

Thanks,
Arvind

6

I’m confused, I have a table that has been filtered and is displayed on the app screen, with headings, data, etc.

I want to submit this table, formatted/cast to a string, to the queue.

image
image1884×394 39.4 KB

However the table variable (and the text field below which is meant to be hidden) violate input schema. Is it possible to send a table of this kind via a queue?

7

@LewisHenderson ,

where are you storing this data?

Thanks,
Arvind

8

It has been extracted from data service, So it currently is generated from the data service.

I am asking for the purposes of customisation, sometimes a client will not want all of the rows, and may remove or change some of the rows from the table. Hence why I want to send the table in it’s current state to the queue.

9

@LewisHenderson ,

Can’t you pass the filter object direct? If you can pass filter object that would be great. Else you can follow an alternate.

  1. Create a filter column
  2. Pass a autogenerated value for each transaction into filter column
  3. Add autogenerated value into Queue field as string
  4. Filter the DS records into process based on filter autogenerated value into process and store into data table.

Thanks,
AK

10

That’s exactly how the app/process is currently operating. which is what I stated in my previous response.

If you understand, the data service is acting as my ‘default’ settings, and I would like to submit a customised Table containing the report information, so that there is not a need to to make permanent changes to the data service for a single custom report they may only require on occasion. Does that make sense?

If this is not currently possible or supported, I understand.

11

I think then it’s not sported passing direct .

15

Hi @LewisHenderson ,

Can you please try the following?

  1. In the "Add to Queue " rule, for the input override, you can use the same filter function you have used for the table data source
  2. This would send only the filtered data to queue

However, the filtered data will have all columns from the entity and not the ones specified in the table control.

1 Like