Need some help with ingesting

Hi ​@aftabp 

It is not a great design for a setup of a RSD file, but you can get the data.

I made a file that gets it and the right data types. You have to remove the txt part of the file names of course.

All the addendumgroups has a named field, so it will continue to increase until you have no more.

If it had no naming it would look better. If you can’t control this you will have to use a query to merge them.

Dear ​@Thomas Lind ,
Thankyou for the reply. 
I managed the code that you have sendt. The problem however arrived where revnr_G2 comes up multiple times. 
With youe code, the marked values are not reterived 

Moving foward with this issue,

I am attaching the whole JSON file this time, and also the RSD file

I have tried different ways to get all addendumGroupNames and the assosiated values in rows but have but couldnt get it.

With this line, i can only get the first value in addendumGroupNames (line 418)

1    <attr name="addendumGroups"                             xs:type="string" readonly="false"         other:xPath="/json/addendumValues/addendumGroups/addendumGroupName" />

This is absurd.
When i use a single response file, like the one above, i get the desired result. 
However, in nested statement i dont get anything from rows.
This works and i get all the addendumGroupNames and values that are for columns

1<api:script xmlns:api="http://apiscript.com/ns?v1" xmlns:xs="http://www.w3.org/2001/XMLSchema">  <!-- See Column Definitions to specify column behavior and use XPaths to extract column values from JSON. -->  <api:info title="addendumGroups" desc="Generated schema file." xmlns:other="http://apiscript.com/ns?v1">    <!-- You can modify the name, type, and column size here. -->    <attr name="addendumGroupName"  			xs:type="string" readonly="false"              other:xPath="/json/addendumValues/addendumGroups/addendumGroupName" />    <attr name="columns"            			xs:type="string" readonly="false"              other:xPath="/json/addendumValues/addendumGroups/rows/columns"      />  </api:info>  <api:set attr="DataModel" value="FLATTENEDDOCUMENTS" />  <api:set attr="URI" value="C:\\temp\\response.json" />  <api:set attr="JSONPath" value="$.addendumValues.addendumGroups;$.addendumValues.addendumGroups.rows" /></api:script>

For this, i get all the addendumGroupNames but values that are for columns are empty

1<api:script xmlns:api="http://apiscript.com/ns?v1" xmlns:xs="http://www.w3.org/2001/XMLSchema">  <!-- Schema information and column definitions for TimeXtender integration -->  <api:info title="addendumGroups" desc="Generated schema file for TimeXtender." xmlns:other="http://apiscript.com/ns?v1">    <!-- Attributes for the main JSON structure -->    <attr name="projectRec" 		xs:type="string" readonly="false" 			   other:xPath="DUMMY" />	<attr name="addendumGroupName"  xs:type="string" readonly="false"              other:xPath="/json/addendumValues/addendumGroups/addendumGroupName" />    <attr name="columns"            xs:type="string" readonly="false"              other:xPath="/json/addendumValues/addendumGroups/rows/columns[0]"      />  </api:info>  <!-- Base URL and settings -->  <api:set attr="urlbase" value="https://my.api.endpoint" />  <api:set attr="touchIn.DataModel" 		value="FLATTENEDDOCUMENTS" />  <api:set attr="touchIn.EnablePaging" 		value="TRUE" />  <api:set attr="touchIn.JSONPath" 			value="$." />  <api:set attr="touchIn.URI" 				value="[urlbase]/api/Project/GetProjects" />  <api:set attr="touchIn.ElementMapPath#" 	value="/json/projectRec" />  <api:set attr="touchIn.ElementMapName#" 	value="file_id" />  <api:set attr="detailsIn.DataModel" 		value="FLATTENEDDOCUMENTS" />  <api:set attr="detailsIn.EnablePaging" value="TRUE" />  <api:set attr="detailsIn.JSONPath" 		value="$.addendumValues.addendumGroups;$.addendumValues.addendumGroups.rows" />  <api:set attr="detailsIn.URITemplate" value="[urlbase]/api/Project/GetProjectByRec/{file_id}" />  <!-- The GET method corresponds to SELECT. Here you can override the default processing of the SELECT statement. The results of processing are pushed to the schema's output. See SELECT Execution for more information. -->	<api:script method="GET">			<api:set attr="touchIn.URI" value="[touchIn.URI]" />		<api:call op="jsonproviderGet" in="touchIn" out="touchOut"> <!-- Clean projectRec -->      <api:set attr="touchin.cleanedProjectRec"                value="[touchOut.file_id | trim()]" />          <!-- Replace projectNumber in URI -->          <api:set attr="detailsIn.URI"                    value="[detailsIn.URITemplate | replace('{file_id}', [touchin.cleanedProjectRec])]" />			<api:call op="jsonproviderGet" in="detailsIn" out="detailsOut">		<api:set attr="out.projectRec"						value="[touchOut.file_id | allownull()]"/>		<api:set attr="out.addendumGroupName" 				value="[detailsOut.addendumGroupName | allownull()]" />		<api:set attr="out.columns" 						value="[detailsOut.columns | allownull()]" />        <api:push item="out" />      </api:call>    </api:call>  </api:script></api:script>

Hi ​@aftabp 

In the addendumValues/addendumGroups/rows/columns[0] path, what sort of data is it supposed to return? 

Can you share a mock json file with this setup? I would like to try it in the new JSON provider we made.

​@Thomas Lind 
I have tried both addendumValues/addendumGroups/rows/columns[0] and addendumValues/addendumGroups/rows[0] but was unable to reterive the desired results. 
You can use response_json.txt. I dont have any real values in there.

As metioned, when i try the response_json (see the attached file from a day ago) i get the values in column

When i try nested, i dont get values in column.
I have stripped down the nested_rsd to include only 3 fields.

​@Thomas Lind , any suggestions? 
The strange part is that the text that should appear in columns, i can see it in log-file.
Why isnt it comming up in TX table !

Somehow, it just worked.
Only thing i did is to delete the RSD i am working on and create RSD from scratch.

Hi ​@aftabp 

Each column sub section contains some individual fields. You can’t make it get those without splitting them all out.

I made a file using FlattenedDocuments you can see what I mean in that as it generated a field for each unique field type there is. I also added a [0] for all fields to get the actual value out of it.

I did not see your newest message before replying to this. Can you send this or did you send it already?

​@aftabp does the above answer your question? If so please help us by marking a best answer. Please let us know if you have any follow up questions

​@Christian Hauggaard 
Unfortunatley no.
The issue was that the values for COLUMN was not showing.  

What eventually solved the issue was that i rewrote the RSD-file, instead of generating it from POSTMAN.

For the values of COLUMN in JSON, i extracred them into one cloumn (json_string) in ODX like this: 
 

Then i created a VIEW in ODX to splitt the values into multiple 
Here is a snippet:

 

1SELECT	JSON_VALUE(json_string, '$.first_value[0]') AS first_value,	JSON_VALUE(json_string, '$.second_value[0]') AS second_valueFROM    MY_TABLE