JiwaAPI

<back to all web services

IM_CSV_StagingQuery

Requires Authentication
IM_CSV_StagingQuery Parameters:
NameParameterData TypeRequiredDescription
RecIDquerystringNo
RecIDStartsWithquerystringNo
RecIDEndsWithquerystringNo
RecIDContainsquerystringNo
RecIDLikequerystringNo
RecIDBetweenquerystring[]No
RecIDInquerystring[]No
BatchIDquerystringNo
BatchIDStartsWithquerystringNo
BatchIDEndsWithquerystringNo
BatchIDContainsquerystringNo
BatchIDLikequerystringNo
BatchIDBetweenquerystring[]No
BatchIDInquerystring[]No
LineNumberqueryint?No
LineNumberGreaterThanOrEqualToqueryint?No
LineNumberGreaterThanqueryint?No
LineNumberLessThanqueryint?No
LineNumberLessThanOrEqualToqueryint?No
LineNumberNotEqualToqueryint?No
LineNumberBetweenqueryint[]No
LineNumberInqueryint[]No
ReferencequerystringNo
ReferenceStartsWithquerystringNo
ReferenceEndsWithquerystringNo
ReferenceContainsquerystringNo
ReferenceLikequerystringNo
ReferenceBetweenquerystring[]No
ReferenceInquerystring[]No
DateCreatedqueryDateTime?No
DateCreatedGreaterThanOrEqualToqueryDateTime?No
DateCreatedGreaterThanqueryDateTime?No
DateCreatedLessThanqueryDateTime?No
DateCreatedLessThanOrEqualToqueryDateTime?No
DateCreatedNotEqualToqueryDateTime?No
DateCreatedBetweenqueryDateTime[]No
DateCreatedInqueryDateTime[]No
ImportStatusquerystringNo
ImportStatusStartsWithquerystringNo
ImportStatusEndsWithquerystringNo
ImportStatusContainsquerystringNo
ImportStatusLikequerystringNo
ImportStatusBetweenquerystring[]No
ImportStatusInquerystring[]No
ImportMessagequerystringNo
ImportMessageStartsWithquerystringNo
ImportMessageEndsWithquerystringNo
ImportMessageContainsquerystringNo
ImportMessageLikequerystringNo
ImportMessageBetweenquerystring[]No
ImportMessageInquerystring[]No
Column1querystringNo
Column1StartsWithquerystringNo
Column1EndsWithquerystringNo
Column1ContainsquerystringNo
Column1LikequerystringNo
Column1Betweenquerystring[]No
Column1Inquerystring[]No
Column2querystringNo
Column2StartsWithquerystringNo
Column2EndsWithquerystringNo
Column2ContainsquerystringNo
Column2LikequerystringNo
Column2Betweenquerystring[]No
Column2Inquerystring[]No
Column3querystringNo
Column3StartsWithquerystringNo
Column3EndsWithquerystringNo
Column3ContainsquerystringNo
Column3LikequerystringNo
Column3Betweenquerystring[]No
Column3Inquerystring[]No
Column4querystringNo
Column4StartsWithquerystringNo
Column4EndsWithquerystringNo
Column4ContainsquerystringNo
Column4LikequerystringNo
Column4Betweenquerystring[]No
Column4Inquerystring[]No
Column5querystringNo
Column5StartsWithquerystringNo
Column5EndsWithquerystringNo
Column5ContainsquerystringNo
Column5LikequerystringNo
Column5Betweenquerystring[]No
Column5Inquerystring[]No
Column6querystringNo
Column6StartsWithquerystringNo
Column6EndsWithquerystringNo
Column6ContainsquerystringNo
Column6LikequerystringNo
Column6Betweenquerystring[]No
Column6Inquerystring[]No
Column7querystringNo
Column7StartsWithquerystringNo
Column7EndsWithquerystringNo
Column7ContainsquerystringNo
Column7LikequerystringNo
Column7Betweenquerystring[]No
Column7Inquerystring[]No
Column8querystringNo
Column8StartsWithquerystringNo
Column8EndsWithquerystringNo
Column8ContainsquerystringNo
Column8LikequerystringNo
Column8Betweenquerystring[]No
Column8Inquerystring[]No
Column9querystringNo
Column9StartsWithquerystringNo
Column9EndsWithquerystringNo
Column9ContainsquerystringNo
Column9LikequerystringNo
Column9Betweenquerystring[]No
Column9Inquerystring[]No
Column10querystringNo
Column10StartsWithquerystringNo
Column10EndsWithquerystringNo
Column10ContainsquerystringNo
Column10LikequerystringNo
Column10Betweenquerystring[]No
Column10Inquerystring[]No
Column11querystringNo
Column11StartsWithquerystringNo
Column11EndsWithquerystringNo
Column11ContainsquerystringNo
Column11LikequerystringNo
Column11Betweenquerystring[]No
Column11Inquerystring[]No
Column12querystringNo
Column12StartsWithquerystringNo
Column12EndsWithquerystringNo
Column12ContainsquerystringNo
Column12LikequerystringNo
Column12Betweenquerystring[]No
Column12Inquerystring[]No
Column13querystringNo
Column13StartsWithquerystringNo
Column13EndsWithquerystringNo
Column13ContainsquerystringNo
Column13LikequerystringNo
Column13Betweenquerystring[]No
Column13Inquerystring[]No
Column14querystringNo
Column14StartsWithquerystringNo
Column14EndsWithquerystringNo
Column14ContainsquerystringNo
Column14LikequerystringNo
Column14Betweenquerystring[]No
Column14Inquerystring[]No
Column15querystringNo
Column15StartsWithquerystringNo
Column15EndsWithquerystringNo
Column15ContainsquerystringNo
Column15LikequerystringNo
Column15Betweenquerystring[]No
Column15Inquerystring[]No
Column16querystringNo
Column16StartsWithquerystringNo
Column16EndsWithquerystringNo
Column16ContainsquerystringNo
Column16LikequerystringNo
Column16Betweenquerystring[]No
Column16Inquerystring[]No
Column17querystringNo
Column17StartsWithquerystringNo
Column17EndsWithquerystringNo
Column17ContainsquerystringNo
Column17LikequerystringNo
Column17Betweenquerystring[]No
Column17Inquerystring[]No
Column18querystringNo
Column18StartsWithquerystringNo
Column18EndsWithquerystringNo
Column18ContainsquerystringNo
Column18LikequerystringNo
Column18Betweenquerystring[]No
Column18Inquerystring[]No
Column19querystringNo
Column19StartsWithquerystringNo
Column19EndsWithquerystringNo
Column19ContainsquerystringNo
Column19LikequerystringNo
Column19Betweenquerystring[]No
Column19Inquerystring[]No
Column20querystringNo
Column20StartsWithquerystringNo
Column20EndsWithquerystringNo
Column20ContainsquerystringNo
Column20LikequerystringNo
Column20Betweenquerystring[]No
Column20Inquerystring[]No
Column21querystringNo
Column21StartsWithquerystringNo
Column21EndsWithquerystringNo
Column21ContainsquerystringNo
Column21LikequerystringNo
Column21Betweenquerystring[]No
Column21Inquerystring[]No
Column22querystringNo
Column22StartsWithquerystringNo
Column22EndsWithquerystringNo
Column22ContainsquerystringNo
Column22LikequerystringNo
Column22Betweenquerystring[]No
Column22Inquerystring[]No
Column23querystringNo
Column23StartsWithquerystringNo
Column23EndsWithquerystringNo
Column23ContainsquerystringNo
Column23LikequerystringNo
Column23Betweenquerystring[]No
Column23Inquerystring[]No
Column24querystringNo
Column24StartsWithquerystringNo
Column24EndsWithquerystringNo
Column24ContainsquerystringNo
Column24LikequerystringNo
Column24Betweenquerystring[]No
Column24Inquerystring[]No
Column25querystringNo
Column25StartsWithquerystringNo
Column25EndsWithquerystringNo
Column25ContainsquerystringNo
Column25LikequerystringNo
Column25Betweenquerystring[]No
Column25Inquerystring[]No
Column26querystringNo
Column26StartsWithquerystringNo
Column26EndsWithquerystringNo
Column26ContainsquerystringNo
Column26LikequerystringNo
Column26Betweenquerystring[]No
Column26Inquerystring[]No
Column27querystringNo
Column27StartsWithquerystringNo
Column27EndsWithquerystringNo
Column27ContainsquerystringNo
Column27LikequerystringNo
Column27Betweenquerystring[]No
Column27Inquerystring[]No
Column28querystringNo
Column28StartsWithquerystringNo
Column28EndsWithquerystringNo
Column28ContainsquerystringNo
Column28LikequerystringNo
Column28Betweenquerystring[]No
Column28Inquerystring[]No
Column29querystringNo
Column29StartsWithquerystringNo
Column29EndsWithquerystringNo
Column29ContainsquerystringNo
Column29LikequerystringNo
Column29Betweenquerystring[]No
Column29Inquerystring[]No
Column30querystringNo
Column30StartsWithquerystringNo
Column30EndsWithquerystringNo
Column30ContainsquerystringNo
Column30LikequerystringNo
Column30Betweenquerystring[]No
Column30Inquerystring[]No
Column31querystringNo
Column31StartsWithquerystringNo
Column31EndsWithquerystringNo
Column31ContainsquerystringNo
Column31LikequerystringNo
Column31Betweenquerystring[]No
Column31Inquerystring[]No
Column32querystringNo
Column32StartsWithquerystringNo
Column32EndsWithquerystringNo
Column32ContainsquerystringNo
Column32LikequerystringNo
Column32Betweenquerystring[]No
Column32Inquerystring[]No
Column33querystringNo
Column33StartsWithquerystringNo
Column33EndsWithquerystringNo
Column33ContainsquerystringNo
Column33LikequerystringNo
Column33Betweenquerystring[]No
Column33Inquerystring[]No
Column34querystringNo
Column34StartsWithquerystringNo
Column34EndsWithquerystringNo
Column34ContainsquerystringNo
Column34LikequerystringNo
Column34Betweenquerystring[]No
Column34Inquerystring[]No
Column35querystringNo
Column35StartsWithquerystringNo
Column35EndsWithquerystringNo
Column35ContainsquerystringNo
Column35LikequerystringNo
Column35Betweenquerystring[]No
Column35Inquerystring[]No
Column36querystringNo
Column36StartsWithquerystringNo
Column36EndsWithquerystringNo
Column36ContainsquerystringNo
Column36LikequerystringNo
Column36Betweenquerystring[]No
Column36Inquerystring[]No
Column37querystringNo
Column37StartsWithquerystringNo
Column37EndsWithquerystringNo
Column37ContainsquerystringNo
Column37LikequerystringNo
Column37Betweenquerystring[]No
Column37Inquerystring[]No
Column38querystringNo
Column38StartsWithquerystringNo
Column38EndsWithquerystringNo
Column38ContainsquerystringNo
Column38LikequerystringNo
Column38Betweenquerystring[]No
Column38Inquerystring[]No
Column39querystringNo
Column39StartsWithquerystringNo
Column39EndsWithquerystringNo
Column39ContainsquerystringNo
Column39LikequerystringNo
Column39Betweenquerystring[]No
Column39Inquerystring[]No
Column40querystringNo
Column40StartsWithquerystringNo
Column40EndsWithquerystringNo
Column40ContainsquerystringNo
Column40LikequerystringNo
Column40Betweenquerystring[]No
Column40Inquerystring[]No
Column41querystringNo
Column41StartsWithquerystringNo
Column41EndsWithquerystringNo
Column41ContainsquerystringNo
Column41LikequerystringNo
Column41Betweenquerystring[]No
Column41Inquerystring[]No
Column42querystringNo
Column42StartsWithquerystringNo
Column42EndsWithquerystringNo
Column42ContainsquerystringNo
Column42LikequerystringNo
Column42Betweenquerystring[]No
Column42Inquerystring[]No
Column43querystringNo
Column43StartsWithquerystringNo
Column43EndsWithquerystringNo
Column43ContainsquerystringNo
Column43LikequerystringNo
Column43Betweenquerystring[]No
Column43Inquerystring[]No
Column44querystringNo
Column44StartsWithquerystringNo
Column44EndsWithquerystringNo
Column44ContainsquerystringNo
Column44LikequerystringNo
Column44Betweenquerystring[]No
Column44Inquerystring[]No
Column45querystringNo
Column45StartsWithquerystringNo
Column45EndsWithquerystringNo
Column45ContainsquerystringNo
Column45LikequerystringNo
Column45Betweenquerystring[]No
Column45Inquerystring[]No
Column46querystringNo
Column46StartsWithquerystringNo
Column46EndsWithquerystringNo
Column46ContainsquerystringNo
Column46LikequerystringNo
Column46Betweenquerystring[]No
Column46Inquerystring[]No
Column47querystringNo
Column47StartsWithquerystringNo
Column47EndsWithquerystringNo
Column47ContainsquerystringNo
Column47LikequerystringNo
Column47Betweenquerystring[]No
Column47Inquerystring[]No
Column48querystringNo
Column48StartsWithquerystringNo
Column48EndsWithquerystringNo
Column48ContainsquerystringNo
Column48LikequerystringNo
Column48Betweenquerystring[]No
Column48Inquerystring[]No
Column49querystringNo
Column49StartsWithquerystringNo
Column49EndsWithquerystringNo
Column49ContainsquerystringNo
Column49LikequerystringNo
Column49Betweenquerystring[]No
Column49Inquerystring[]No
Column50querystringNo
Column50StartsWithquerystringNo
Column50EndsWithquerystringNo
Column50ContainsquerystringNo
Column50LikequerystringNo
Column50Betweenquerystring[]No
Column50Inquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
IM_CSV_Staging Parameters:
NameParameterData TypeRequiredDescription
RecIDformstringNo
BatchIDformstringNo
LineNumberformintNo
ReferenceformstringNo
DateCreatedformDateTimeNo
ImportStatusformstringNo
ImportMessageformstringNo
Column1formstringNo
Column2formstringNo
Column3formstringNo
Column4formstringNo
Column5formstringNo
Column6formstringNo
Column7formstringNo
Column8formstringNo
Column9formstringNo
Column10formstringNo
Column11formstringNo
Column12formstringNo
Column13formstringNo
Column14formstringNo
Column15formstringNo
Column16formstringNo
Column17formstringNo
Column18formstringNo
Column19formstringNo
Column20formstringNo
Column21formstringNo
Column22formstringNo
Column23formstringNo
Column24formstringNo
Column25formstringNo
Column26formstringNo
Column27formstringNo
Column28formstringNo
Column29formstringNo
Column30formstringNo
Column31formstringNo
Column32formstringNo
Column33formstringNo
Column34formstringNo
Column35formstringNo
Column36formstringNo
Column37formstringNo
Column38formstringNo
Column39formstringNo
Column40formstringNo
Column41formstringNo
Column42formstringNo
Column43formstringNo
Column44formstringNo
Column45formstringNo
Column46formstringNo
Column47formstringNo
Column48formstringNo
Column49formstringNo
Column50formstringNo
QueryResponse<T> Parameters:
NameParameterData TypeRequiredDescription
OffsetformintNo
TotalformintNo
ResultsformList<T>No
MetaformDictionary<string, string>No
ResponseStatusformResponseStatusNo

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"}}}