JiwaAPI

IM_CSV_StagingQuery

**IM_CSV_StagingQuery** Parameters:
Name	Parameter	Data Type	Required
RecID	query	string	No
RecIDStartsWith	query	string	No
RecIDEndsWith	query	string	No
RecIDContains	query	string	No
RecIDLike	query	string	No
RecIDBetween	query	string[]	No
RecIDIn	query	string[]	No
BatchID	query	string	No
BatchIDStartsWith	query	string	No
BatchIDEndsWith	query	string	No
BatchIDContains	query	string	No
BatchIDLike	query	string	No
BatchIDBetween	query	string[]	No
BatchIDIn	query	string[]	No
LineNumber	query	int?	No
LineNumberGreaterThanOrEqualTo	query	int?	No
LineNumberGreaterThan	query	int?	No
LineNumberLessThan	query	int?	No
LineNumberLessThanOrEqualTo	query	int?	No
LineNumberNotEqualTo	query	int?	No
LineNumberBetween	query	int[]	No
LineNumberIn	query	int[]	No
Reference	query	string	No
ReferenceStartsWith	query	string	No
ReferenceEndsWith	query	string	No
ReferenceContains	query	string	No
ReferenceLike	query	string	No
ReferenceBetween	query	string[]	No
ReferenceIn	query	string[]	No
DateCreated	query	DateTime?	No
DateCreatedGreaterThanOrEqualTo	query	DateTime?	No
DateCreatedGreaterThan	query	DateTime?	No
DateCreatedLessThan	query	DateTime?	No
DateCreatedLessThanOrEqualTo	query	DateTime?	No
DateCreatedNotEqualTo	query	DateTime?	No
DateCreatedBetween	query	DateTime[]	No
DateCreatedIn	query	DateTime[]	No
ImportStatus	query	string	No
ImportStatusStartsWith	query	string	No
ImportStatusEndsWith	query	string	No
ImportStatusContains	query	string	No
ImportStatusLike	query	string	No
ImportStatusBetween	query	string[]	No
ImportStatusIn	query	string[]	No
ImportMessage	query	string	No
ImportMessageStartsWith	query	string	No
ImportMessageEndsWith	query	string	No
ImportMessageContains	query	string	No
ImportMessageLike	query	string	No
ImportMessageBetween	query	string[]	No
ImportMessageIn	query	string[]	No
Column1	query	string	No
Column1StartsWith	query	string	No
Column1EndsWith	query	string	No
Column1Contains	query	string	No
Column1Like	query	string	No
Column1Between	query	string[]	No
Column1In	query	string[]	No
Column2	query	string	No
Column2StartsWith	query	string	No
Column2EndsWith	query	string	No
Column2Contains	query	string	No
Column2Like	query	string	No
Column2Between	query	string[]	No
Column2In	query	string[]	No
Column3	query	string	No
Column3StartsWith	query	string	No
Column3EndsWith	query	string	No
Column3Contains	query	string	No
Column3Like	query	string	No
Column3Between	query	string[]	No
Column3In	query	string[]	No
Column4	query	string	No
Column4StartsWith	query	string	No
Column4EndsWith	query	string	No
Column4Contains	query	string	No
Column4Like	query	string	No
Column4Between	query	string[]	No
Column4In	query	string[]	No
Column5	query	string	No
Column5StartsWith	query	string	No
Column5EndsWith	query	string	No
Column5Contains	query	string	No
Column5Like	query	string	No
Column5Between	query	string[]	No
Column5In	query	string[]	No
Column6	query	string	No
Column6StartsWith	query	string	No
Column6EndsWith	query	string	No
Column6Contains	query	string	No
Column6Like	query	string	No
Column6Between	query	string[]	No
Column6In	query	string[]	No
Column7	query	string	No
Column7StartsWith	query	string	No
Column7EndsWith	query	string	No
Column7Contains	query	string	No
Column7Like	query	string	No
Column7Between	query	string[]	No
Column7In	query	string[]	No
Column8	query	string	No
Column8StartsWith	query	string	No
Column8EndsWith	query	string	No
Column8Contains	query	string	No
Column8Like	query	string	No
Column8Between	query	string[]	No
Column8In	query	string[]	No
Column9	query	string	No
Column9StartsWith	query	string	No
Column9EndsWith	query	string	No
Column9Contains	query	string	No
Column9Like	query	string	No
Column9Between	query	string[]	No
Column9In	query	string[]	No
Column10	query	string	No
Column10StartsWith	query	string	No
Column10EndsWith	query	string	No
Column10Contains	query	string	No
Column10Like	query	string	No
Column10Between	query	string[]	No
Column10In	query	string[]	No
Column11	query	string	No
Column11StartsWith	query	string	No
Column11EndsWith	query	string	No
Column11Contains	query	string	No
Column11Like	query	string	No
Column11Between	query	string[]	No
Column11In	query	string[]	No
Column12	query	string	No
Column12StartsWith	query	string	No
Column12EndsWith	query	string	No
Column12Contains	query	string	No
Column12Like	query	string	No
Column12Between	query	string[]	No
Column12In	query	string[]	No
Column13	query	string	No
Column13StartsWith	query	string	No
Column13EndsWith	query	string	No
Column13Contains	query	string	No
Column13Like	query	string	No
Column13Between	query	string[]	No
Column13In	query	string[]	No
Column14	query	string	No
Column14StartsWith	query	string	No
Column14EndsWith	query	string	No
Column14Contains	query	string	No
Column14Like	query	string	No
Column14Between	query	string[]	No
Column14In	query	string[]	No
Column15	query	string	No
Column15StartsWith	query	string	No
Column15EndsWith	query	string	No
Column15Contains	query	string	No
Column15Like	query	string	No
Column15Between	query	string[]	No
Column15In	query	string[]	No
Column16	query	string	No
Column16StartsWith	query	string	No
Column16EndsWith	query	string	No
Column16Contains	query	string	No
Column16Like	query	string	No
Column16Between	query	string[]	No
Column16In	query	string[]	No
Column17	query	string	No
Column17StartsWith	query	string	No
Column17EndsWith	query	string	No
Column17Contains	query	string	No
Column17Like	query	string	No
Column17Between	query	string[]	No
Column17In	query	string[]	No
Column18	query	string	No
Column18StartsWith	query	string	No
Column18EndsWith	query	string	No
Column18Contains	query	string	No
Column18Like	query	string	No
Column18Between	query	string[]	No
Column18In	query	string[]	No
Column19	query	string	No
Column19StartsWith	query	string	No
Column19EndsWith	query	string	No
Column19Contains	query	string	No
Column19Like	query	string	No
Column19Between	query	string[]	No
Column19In	query	string[]	No
Column20	query	string	No
Column20StartsWith	query	string	No
Column20EndsWith	query	string	No
Column20Contains	query	string	No
Column20Like	query	string	No
Column20Between	query	string[]	No
Column20In	query	string[]	No
Column21	query	string	No
Column21StartsWith	query	string	No
Column21EndsWith	query	string	No
Column21Contains	query	string	No
Column21Like	query	string	No
Column21Between	query	string[]	No
Column21In	query	string[]	No
Column22	query	string	No
Column22StartsWith	query	string	No
Column22EndsWith	query	string	No
Column22Contains	query	string	No
Column22Like	query	string	No
Column22Between	query	string[]	No
Column22In	query	string[]	No
Column23	query	string	No
Column23StartsWith	query	string	No
Column23EndsWith	query	string	No
Column23Contains	query	string	No
Column23Like	query	string	No
Column23Between	query	string[]	No
Column23In	query	string[]	No
Column24	query	string	No
Column24StartsWith	query	string	No
Column24EndsWith	query	string	No
Column24Contains	query	string	No
Column24Like	query	string	No
Column24Between	query	string[]	No
Column24In	query	string[]	No
Column25	query	string	No
Column25StartsWith	query	string	No
Column25EndsWith	query	string	No
Column25Contains	query	string	No
Column25Like	query	string	No
Column25Between	query	string[]	No
Column25In	query	string[]	No
Column26	query	string	No
Column26StartsWith	query	string	No
Column26EndsWith	query	string	No
Column26Contains	query	string	No
Column26Like	query	string	No
Column26Between	query	string[]	No
Column26In	query	string[]	No
Column27	query	string	No
Column27StartsWith	query	string	No
Column27EndsWith	query	string	No
Column27Contains	query	string	No
Column27Like	query	string	No
Column27Between	query	string[]	No
Column27In	query	string[]	No
Column28	query	string	No
Column28StartsWith	query	string	No
Column28EndsWith	query	string	No
Column28Contains	query	string	No
Column28Like	query	string	No
Column28Between	query	string[]	No
Column28In	query	string[]	No
Column29	query	string	No
Column29StartsWith	query	string	No
Column29EndsWith	query	string	No
Column29Contains	query	string	No
Column29Like	query	string	No
Column29Between	query	string[]	No
Column29In	query	string[]	No
Column30	query	string	No
Column30StartsWith	query	string	No
Column30EndsWith	query	string	No
Column30Contains	query	string	No
Column30Like	query	string	No
Column30Between	query	string[]	No
Column30In	query	string[]	No
Column31	query	string	No
Column31StartsWith	query	string	No
Column31EndsWith	query	string	No
Column31Contains	query	string	No
Column31Like	query	string	No
Column31Between	query	string[]	No
Column31In	query	string[]	No
Column32	query	string	No
Column32StartsWith	query	string	No
Column32EndsWith	query	string	No
Column32Contains	query	string	No
Column32Like	query	string	No
Column32Between	query	string[]	No
Column32In	query	string[]	No
Column33	query	string	No
Column33StartsWith	query	string	No
Column33EndsWith	query	string	No
Column33Contains	query	string	No
Column33Like	query	string	No
Column33Between	query	string[]	No
Column33In	query	string[]	No
Column34	query	string	No
Column34StartsWith	query	string	No
Column34EndsWith	query	string	No
Column34Contains	query	string	No
Column34Like	query	string	No
Column34Between	query	string[]	No
Column34In	query	string[]	No
Column35	query	string	No
Column35StartsWith	query	string	No
Column35EndsWith	query	string	No
Column35Contains	query	string	No
Column35Like	query	string	No
Column35Between	query	string[]	No
Column35In	query	string[]	No
Column36	query	string	No
Column36StartsWith	query	string	No
Column36EndsWith	query	string	No
Column36Contains	query	string	No
Column36Like	query	string	No
Column36Between	query	string[]	No
Column36In	query	string[]	No
Column37	query	string	No
Column37StartsWith	query	string	No
Column37EndsWith	query	string	No
Column37Contains	query	string	No
Column37Like	query	string	No
Column37Between	query	string[]	No
Column37In	query	string[]	No
Column38	query	string	No
Column38StartsWith	query	string	No
Column38EndsWith	query	string	No
Column38Contains	query	string	No
Column38Like	query	string	No
Column38Between	query	string[]	No
Column38In	query	string[]	No
Column39	query	string	No
Column39StartsWith	query	string	No
Column39EndsWith	query	string	No
Column39Contains	query	string	No
Column39Like	query	string	No
Column39Between	query	string[]	No
Column39In	query	string[]	No
Column40	query	string	No
Column40StartsWith	query	string	No
Column40EndsWith	query	string	No
Column40Contains	query	string	No
Column40Like	query	string	No
Column40Between	query	string[]	No
Column40In	query	string[]	No
Column41	query	string	No
Column41StartsWith	query	string	No
Column41EndsWith	query	string	No
Column41Contains	query	string	No
Column41Like	query	string	No
Column41Between	query	string[]	No
Column41In	query	string[]	No
Column42	query	string	No
Column42StartsWith	query	string	No
Column42EndsWith	query	string	No
Column42Contains	query	string	No
Column42Like	query	string	No
Column42Between	query	string[]	No
Column42In	query	string[]	No
Column43	query	string	No
Column43StartsWith	query	string	No
Column43EndsWith	query	string	No
Column43Contains	query	string	No
Column43Like	query	string	No
Column43Between	query	string[]	No
Column43In	query	string[]	No
Column44	query	string	No
Column44StartsWith	query	string	No
Column44EndsWith	query	string	No
Column44Contains	query	string	No
Column44Like	query	string	No
Column44Between	query	string[]	No
Column44In	query	string[]	No
Column45	query	string	No
Column45StartsWith	query	string	No
Column45EndsWith	query	string	No
Column45Contains	query	string	No
Column45Like	query	string	No
Column45Between	query	string[]	No
Column45In	query	string[]	No
Column46	query	string	No
Column46StartsWith	query	string	No
Column46EndsWith	query	string	No
Column46Contains	query	string	No
Column46Like	query	string	No
Column46Between	query	string[]	No
Column46In	query	string[]	No
Column47	query	string	No
Column47StartsWith	query	string	No
Column47EndsWith	query	string	No
Column47Contains	query	string	No
Column47Like	query	string	No
Column47Between	query	string[]	No
Column47In	query	string[]	No
Column48	query	string	No
Column48StartsWith	query	string	No
Column48EndsWith	query	string	No
Column48Contains	query	string	No
Column48Like	query	string	No
Column48Between	query	string[]	No
Column48In	query	string[]	No
Column49	query	string	No
Column49StartsWith	query	string	No
Column49EndsWith	query	string	No
Column49Contains	query	string	No
Column49Like	query	string	No
Column49Between	query	string[]	No
Column49In	query	string[]	No
Column50	query	string	No
Column50StartsWith	query	string	No
Column50EndsWith	query	string	No
Column50Contains	query	string	No
Column50Like	query	string	No
Column50Between	query	string[]	No
Column50In	query	string[]	No

**QueryBase** Parameters:
Name	Parameter	Data Type	Required
Skip	form	int?	No
Take	form	int?	No
OrderBy	form	string	No
OrderByDesc	form	string	No
Include	form	string	No
Fields	form	string	No
Meta	form	Dictionary<string, string>	No

**IM_CSV_Staging** Parameters:
Name	Parameter	Data Type	Required
RecID	form	string	No
BatchID	form	string	No
LineNumber	form	int	No
Reference	form	string	No
DateCreated	form	DateTime	No
ImportStatus	form	string	No
ImportMessage	form	string	No
Column1	form	string	No
Column2	form	string	No
Column3	form	string	No
Column4	form	string	No
Column5	form	string	No
Column6	form	string	No
Column7	form	string	No
Column8	form	string	No
Column9	form	string	No
Column10	form	string	No
Column11	form	string	No
Column12	form	string	No
Column13	form	string	No
Column14	form	string	No
Column15	form	string	No
Column16	form	string	No
Column17	form	string	No
Column18	form	string	No
Column19	form	string	No
Column20	form	string	No
Column21	form	string	No
Column22	form	string	No
Column23	form	string	No
Column24	form	string	No
Column25	form	string	No
Column26	form	string	No
Column27	form	string	No
Column28	form	string	No
Column29	form	string	No
Column30	form	string	No
Column31	form	string	No
Column32	form	string	No
Column33	form	string	No
Column34	form	string	No
Column35	form	string	No
Column36	form	string	No
Column37	form	string	No
Column38	form	string	No
Column39	form	string	No
Column40	form	string	No
Column41	form	string	No
Column42	form	string	No
Column43	form	string	No
Column44	form	string	No
Column45	form	string	No
Column46	form	string	No
Column47	form	string	No
Column48	form	string	No
Column49	form	string	No
Column50	form	string	No

**QueryResponse<T>** Parameters:
Name	Parameter	Data Type	Required
Offset	form	int	No
Total	form	int	No
Results	form	List<T>	No
Meta	form	Dictionary<string, string>	No
ResponseStatus	form	ResponseStatus	No

To override the Content-type in your clients, use the HTTP Accept Header, append the .json suffix or ?format=json

To embed the response in a jsonp callback, append ?callback=myCallback

HTTP + JSON

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /json/reply/IM_CSV_StagingQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/json
Content-Type: application/json
Content-Length: length

{"RecID":"String","RecIDStartsWith":"String","RecIDEndsWith":"String","RecIDContains":"String","RecIDLike":"String","RecIDBetween":["String"],"RecIDIn":["String"],"BatchID":"String","BatchIDStartsWith":"String","BatchIDEndsWith":"String","BatchIDContains":"String","BatchIDLike":"String","BatchIDBetween":["String"],"BatchIDIn":["String"],"LineNumber":0,"LineNumberGreaterThanOrEqualTo":0,"LineNumberGreaterThan":0,"LineNumberLessThan":0,"LineNumberLessThanOrEqualTo":0,"LineNumberNotEqualTo":0,"LineNumberBetween":[0],"LineNumberIn":[0],"Reference":"String","ReferenceStartsWith":"String","ReferenceEndsWith":"String","ReferenceContains":"String","ReferenceLike":"String","ReferenceBetween":["String"],"ReferenceIn":["String"],"DateCreated":"0001-01-01T00:00:00.0000000","DateCreatedGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","DateCreatedGreaterThan":"0001-01-01T00:00:00.0000000","DateCreatedLessThan":"0001-01-01T00:00:00.0000000","DateCreatedLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","DateCreatedNotEqualTo":"0001-01-01T00:00:00.0000000","DateCreatedBetween":["0001-01-01T00:00:00.0000000"],"DateCreatedIn":["0001-01-01T00:00:00.0000000"],"ImportStatus":"String","ImportStatusStartsWith":"String","ImportStatusEndsWith":"String","ImportStatusContains":"String","ImportStatusLike":"String","ImportStatusBetween":["String"],"ImportStatusIn":["String"],"ImportMessage":"String","ImportMessageStartsWith":"String","ImportMessageEndsWith":"String","ImportMessageContains":"String","ImportMessageLike":"String","ImportMessageBetween":["String"],"ImportMessageIn":["String"],"Column1":"String","Column1StartsWith":"String","Column1EndsWith":"String","Column1Contains":"String","Column1Like":"String","Column1Between":["String"],"Column1In":["String"],"Column2":"String","Column2StartsWith":"String","Column2EndsWith":"String","Column2Contains":"String","Column2Like":"String","Column2Between":["String"],"Column2In":["String"],"Column3":"String","Column3StartsWith":"String","Column3EndsWith":"String","Column3Contains":"String","Column3Like":"String","Column3Between":["String"],"Column3In":["String"],"Column4":"String","Column4StartsWith":"String","Column4EndsWith":"String","Column4Contains":"String","Column4Like":"String","Column4Between":["String"],"Column4In":["String"],"Column5":"String","Column5StartsWith":"String","Column5EndsWith":"String","Column5Contains":"String","Column5Like":"String","Column5Between":["String"],"Column5In":["String"],"Column6":"String","Column6StartsWith":"String","Column6EndsWith":"String","Column6Contains":"String","Column6Like":"String","Column6Between":["String"],"Column6In":["String"],"Column7":"String","Column7StartsWith":"String","Column7EndsWith":"String","Column7Contains":"String","Column7Like":"String","Column7Between":["String"],"Column7In":["String"],"Column8":"String","Column8StartsWith":"String","Column8EndsWith":"String","Column8Contains":"String","Column8Like":"String","Column8Between":["String"],"Column8In":["String"],"Column9":"String","Column9StartsWith":"String","Column9EndsWith":"String","Column9Contains":"String","Column9Like":"String","Column9Between":["String"],"Column9In":["String"],"Column10":"String","Column10StartsWith":"String","Column10EndsWith":"String","Column10Contains":"String","Column10Like":"String","Column10Between":["String"],"Column10In":["String"],"Column11":"String","Column11StartsWith":"String","Column11EndsWith":"String","Column11Contains":"String","Column11Like":"String","Column11Between":["String"],"Column11In":["String"],"Column12":"String","Column12StartsWith":"String","Column12EndsWith":"String","Column12Contains":"String","Column12Like":"String","Column12Between":["String"],"Column12In":["String"],"Column13":"String","Column13StartsWith":"String","Column13EndsWith":"String","Column13Contains":"String","Column13Like":"String","Column13Between":["String"],"Column13In":["String"],"Column14":"String","Column14StartsWith":"String","Column14EndsWith":"String","Column14Contains":"String","Column14Like":"String","Column14Between":["String"],"Column14In":["String"],"Column15":"String","Column15StartsWith":"String","Column15EndsWith":"String","Column15Contains":"String","Column15Like":"String","Column15Between":["String"],"Column15In":["String"],"Column16":"String","Column16StartsWith":"String","Column16EndsWith":"String","Column16Contains":"String","Column16Like":"String","Column16Between":["String"],"Column16In":["String"],"Column17":"String","Column17StartsWith":"String","Column17EndsWith":"String","Column17Contains":"String","Column17Like":"String","Column17Between":["String"],"Column17In":["String"],"Column18":"String","Column18StartsWith":"String","Column18EndsWith":"String","Column18Contains":"String","Column18Like":"String","Column18Between":["String"],"Column18In":["String"],"Column19":"String","Column19StartsWith":"String","Column19EndsWith":"String","Column19Contains":"String","Column19Like":"String","Column19Between":["String"],"Column19In":["String"],"Column20":"String","Column20StartsWith":"String","Column20EndsWith":"String","Column20Contains":"String","Column20Like":"String","Column20Between":["String"],"Column20In":["String"],"Column21":"String","Column21StartsWith":"String","Column21EndsWith":"String","Column21Contains":"String","Column21Like":"String","Column21Between":["String"],"Column21In":["String"],"Column22":"String","Column22StartsWith":"String","Column22EndsWith":"String","Column22Contains":"String","Column22Like":"String","Column22Between":["String"],"Column22In":["String"],"Column23":"String","Column23StartsWith":"String","Column23EndsWith":"String","Column23Contains":"String","Column23Like":"String","Column23Between":["String"],"Column23In":["String"],"Column24":"String","Column24StartsWith":"String","Column24EndsWith":"String","Column24Contains":"String","Column24Like":"String","Column24Between":["String"],"Column24In":["String"],"Column25":"String","Column25StartsWith":"String","Column25EndsWith":"String","Column25Contains":"String","Column25Like":"String","Column25Between":["String"],"Column25In":["String"],"Column26":"String","Column26StartsWith":"String","Column26EndsWith":"String","Column26Contains":"String","Column26Like":"String","Column26Between":["String"],"Column26In":["String"],"Column27":"String","Column27StartsWith":"String","Column27EndsWith":"String","Column27Contains":"String","Column27Like":"String","Column27Between":["String"],"Column27In":["String"],"Column28":"String","Column28StartsWith":"String","Column28EndsWith":"String","Column28Contains":"String","Column28Like":"String","Column28Between":["String"],"Column28In":["String"],"Column29":"String","Column29StartsWith":"String","Column29EndsWith":"String","Column29Contains":"String","Column29Like":"String","Column29Between":["String"],"Column29In":["String"],"Column30":"String","Column30StartsWith":"String","Column30EndsWith":"String","Column30Contains":"String","Column30Like":"String","Column30Between":["String"],"Column30In":["String"],"Column31":"String","Column31StartsWith":"String","Column31EndsWith":"String","Column31Contains":"String","Column31Like":"String","Column31Between":["String"],"Column31In":["String"],"Column32":"String","Column32StartsWith":"String","Column32EndsWith":"String","Column32Contains":"String","Column32Like":"String","Column32Between":["String"],"Column32In":["String"],"Column33":"String","Column33StartsWith":"String","Column33EndsWith":"String","Column33Contains":"String","Column33Like":"String","Column33Between":["String"],"Column33In":["String"],"Column34":"String","Column34StartsWith":"String","Column34EndsWith":"String","Column34Contains":"String","Column34Like":"String","Column34Between":["String"],"Column34In":["String"],"Column35":"String","Column35StartsWith":"String","Column35EndsWith":"String","Column35Contains":"String","Column35Like":"String","Column35Between":["String"],"Column35In":["String"],"Column36":"String","Column36StartsWith":"String","Column36EndsWith":"String","Column36Contains":"String","Column36Like":"String","Column36Between":["String"],"Column36In":["String"],"Column37":"String","Column37StartsWith":"String","Column37EndsWith":"String","Column37Contains":"String","Column37Like":"String","Column37Between":["String"],"Column37In":["String"],"Column38":"String","Column38StartsWith":"String","Column38EndsWith":"String","Column38Contains":"String","Column38Like":"String","Column38Between":["String"],"Column38In":["String"],"Column39":"String","Column39StartsWith":"String","Column39EndsWith":"String","Column39Contains":"String","Column39Like":"String","Column39Between":["String"],"Column39In":["String"],"Column40":"String","Column40StartsWith":"String","Column40EndsWith":"String","Column40Contains":"String","Column40Like":"String","Column40Between":["String"],"Column40In":["String"],"Column41":"String","Column41StartsWith":"String","Column41EndsWith":"String","Column41Contains":"String","Column41Like":"String","Column41Between":["String"],"Column41In":["String"],"Column42":"String","Column42StartsWith":"String","Column42EndsWith":"String","Column42Contains":"String","Column42Like":"String","Column42Between":["String"],"Column42In":["String"],"Column43":"String","Column43StartsWith":"String","Column43EndsWith":"String","Column43Contains":"String","Column43Like":"String","Column43Between":["String"],"Column43In":["String"],"Column44":"String","Column44StartsWith":"String","Column44EndsWith":"String","Column44Contains":"String","Column44Like":"String","Column44Between":["String"],"Column44In":["String"],"Column45":"String","Column45StartsWith":"String","Column45EndsWith":"String","Column45Contains":"String","Column45Like":"String","Column45Between":["String"],"Column45In":["String"],"Column46":"String","Column46StartsWith":"String","Column46EndsWith":"String","Column46Contains":"String","Column46Like":"String","Column46Between":["String"],"Column46In":["String"],"Column47":"String","Column47StartsWith":"String","Column47EndsWith":"String","Column47Contains":"String","Column47Like":"String","Column47Between":["String"],"Column47In":["String"],"Column48":"String","Column48StartsWith":"String","Column48EndsWith":"String","Column48Contains":"String","Column48Like":"String","Column48Between":["String"],"Column48In":["String"],"Column49":"String","Column49StartsWith":"String","Column49EndsWith":"String","Column49Contains":"String","Column49Like":"String","Column49Between":["String"],"Column49In":["String"],"Column50":"String","Column50StartsWith":"String","Column50EndsWith":"String","Column50Contains":"String","Column50Like":"String","Column50Between":["String"],"Column50In":["String"],"Skip":0,"Take":0,"OrderBy":"String","OrderByDesc":"String","Include":"String","Fields":"String","Meta":{"String":"String"}}

HTTP/1.1 200 OK
Content-Type: application/json
Content-Length: length

{"Results":[{"RecID":"String","BatchID":"String","Reference":"String","ImportStatus":"String","ImportMessage":"String","Column1":"String","Column2":"String","Column3":"String","Column4":"String","Column5":"String","Column6":"String","Column7":"String","Column8":"String","Column9":"String","Column10":"String","Column11":"String","Column12":"String","Column13":"String","Column14":"String","Column15":"String","Column16":"String","Column17":"String","Column18":"String","Column19":"String","Column20":"String","Column21":"String","Column22":"String","Column23":"String","Column24":"String","Column25":"String","Column26":"String","Column27":"String","Column28":"String","Column29":"String","Column30":"String","Column31":"String","Column32":"String","Column33":"String","Column34":"String","Column35":"String","Column36":"String","Column37":"String","Column38":"String","Column39":"String","Column40":"String","Column41":"String","Column42":"String","Column43":"String","Column44":"String","Column45":"String","Column46":"String","Column47":"String","Column48":"String","Column49":"String","Column50":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}